Formula to dictate which type of data to print in multi-data field 1

[spgardner2000]

I need a formula that will choose the value to insert for a field based on whether another field is "True" or "False". I've tried basic If/Then formulas with no success.

Determining Field: {FUNDSRC.FS_STATE} (value either T or F)

Affected Field: {FUNDSRC.FS_AMOUNTREQ} (will show either state funds or county funds requested depending on the prior field)

I need the final report to show the following:

State Funds Requested:
County Funds Requested:

For the same record.

I hope that this is enough information to help. Thank you.

 

[lbass]

Create two formulas:

//{@state}:
if {FUNDSRC.FS_STATE} = "T" then {FUNDSRC.FS_AMOUNTREQ}

//{@county}:
if {FUNDSRC.FS_STATE} = "F" then {FUNDSRC.FS_AMOUNTREQ}

Right click on each formula and insert a summary at the group or report level.

-LB

 

[spgardner2000]

Thank you. The County formula worked, but the state formula is entering $0.00, even if there should be a value to enter.

Any suggestions?

 

[lbass]

If you place the two fields (not the formulas) in your detail section, what results do you get? Just want to make sure that "T" and "F" are the only options for the FS_State field. Can there be nulls, and if so, how are they interpreted?

-LB