Calculated Field Formula IIF

[jtenbrook]

I am trying to create a calculated field that will return the result of another Calculated field,R_Split, if the conditions are met, if they are not met then it would be blank. I can get it to work in all ways but the R_Split portion.______IIF(UNIT= ^R4*****^ OR UNIT =^R3*****^ OR UNIT= ^R2*****^ OR UNIT=^R0L**^, R_Split, ^ ^)

[kfleming]

Are the * characters literal values in the UNIT field?____Kathleen__R&R Support

[jtenbrook]

Unit Field ^R3****^ represent the actual unit types.

[kfleming]

Try:____IIF(^R4*****^$UNIT OR ^R3*****^$UNIT OR ^R2*****^$UNIT OR ^R0L**^$UNIT, R_Split, ^ ^)______Kathleen__R&R Support

[jtenbrook]

nope, invalid argument.

[kfleming]

Is R_Split a numeric field?__If it is, use 0 rather than ^ ^ as the false argument.____Kathleen__R&R Support

[jtenbrook]

Arrggg. That is so simple, that worked thanks so much.