IF statement

[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______

[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

[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?