Using @EVAL
Use @EVAL to select a value based on a series of independent conditional tests.
@EVAL (AMOUNT > 10000, 'high amount', AMOUNT > 5000, 'somewhat high')
This example returns the following:
-
high amountifAMOUNTis greater than10000 -
somewhat highifAMOUNTis greater than5000, and less than or equal to10000, (unless the prior condition was satisfied) -
A
FIELD_MISSINGindication if neither condition is satisfied.