Page 1 of 1
IF statement
Posted: Thu Apr 28, 2005 4:47 pm
by morgentb
I am trying to do an if statement that pulls either data from a field or runs a calculated field. IIF(ACC_COD=^26^,CLM_NUM,hrrate)__Is this possible? Is there another way to do this? I keep getting "Invalid Argument"____Barbara______
=> RE: IF statement
Posted: Fri Apr 29, 2005 6:58 am
by kfleming
Both return fields (CLM_NUM and hrrate) need to be of the same datatype. So if one is numeric, the other has to be numeric as well.____Kathleen__R&R Support
==> RE: IF statement
Posted: Fri Apr 29, 2005 7:43 am
by morgentb
They are both numeric the difference is the hrate is a calculated field that produces a numeric value. Is there any way I can get what I need. Maybe not a calculated if statement but something else?