Page 1 of 1
Calculated Field Formula IIF
Posted: Fri Mar 13, 2009 6:02 pm
by 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, ^ ^)
=> RE: Calculated Field Formula IIF
Posted: Tue Mar 17, 2009 8:04 am
by kfleming
Are the * characters literal values in the UNIT field?____Kathleen__R&R Support
==> RE: Calculated Field Formula IIF
Posted: Tue Mar 17, 2009 11:21 am
by jtenbrook
Unit Field ^R3****^ represent the actual unit types.
===> RE: Calculated Field Formula IIF
Posted: Fri Mar 20, 2009 10:24 am
by kfleming
Try:____IIF(^R4*****^$UNIT OR ^R3*****^$UNIT OR ^R2*****^$UNIT OR ^R0L**^$UNIT, R_Split, ^ ^)______Kathleen__R&R Support
====> RE: Calculated Field Formula IIF
Posted: Sun Mar 22, 2009 12:59 pm
by jtenbrook
nope, invalid argument.
=====> RE: Calculated Field Formula IIF
Posted: Mon Mar 23, 2009 8:35 am
by kfleming
Is R_Split a numeric field?__If it is, use 0 rather than ^ ^ as the false argument.____Kathleen__R&R Support
======> RE: Calculated Field Formula IIF
Posted: Mon Mar 23, 2009 4:42 pm
by jtenbrook
Arrggg. That is so simple, that worked thanks so much.