What is the syntax in Expression Assistant for the following example: I have a data field that contains either a Y or an M. If there is a Y, I want the report to say "Years", and if it is an M, I want the report to say "Months".
Hi Sylvia,
You may use an expression like this one (replacing "MyField" by your data field name)...
=If(MyField.ToUpper() ="Y", "Years", If(MyField.ToUpper() ="M", "Months", MyField))
The IF(boolExpression, thenExpression, elseExpression) function it's located at the "Other" functions category on Expression Assistant
Regards,
CJC
Ok. That worked. Thanks!
But - I don't know how in the world I would have figured that out myself. Is there documentation on this somewhere? Or perhaps this syntax is patterned after some programming language I'm not familiar with?