Logical Functions | Calculation Signatures

Logical functions allow comparative tests to be evaluated and return differing results based on those comparisons. They also allow you to work with variables.

Table 5.7. Logical Functions
Syntax	Data Type Returned
`Case ( test1; result1 {; test2; result2; defaultResult...} )`	Text, Number, Date, Time, Timestamp, Container
`Choose ( test; result0 {; result1; result2...} )`	Text, Number, Date, Time, Timestamp, Container
`Evaluate ( expression {; [ field1; field2; ...]} )`	Text, Number, Date, Time, Timestamp, Container
`EvaluationError ( expression )`	Number
`GetAsBoolean ( data )`	Number
`GetField ( fieldName )`	Text, Number, Date, Time, Timestamp, Container
`GetNthRecord ( fieldName; recordNumber )`	Text, Number, Date, Time, Timestamp, Container
`If ( test; result1; result2 )`	Text, Number, Date, Time, Timestamp, Container
`IsEmpty ( expression )`	Number
`IsValid ( expression )`	Number
`IsValidExpression ( expression )`	Number
`Let ( {[} var1=expression1 {; var2=expression2 ...]}; calculation )`	Text, Number, Date, Time, Timestamp, Container
`Lookup ( sourceField {; failExpression })`	Text, Number, Date, Time, Timestamp, Container
`LookupNext ( sourceField; lower/higher Flag )`	Text, Number, Date, Time, Timestamp, Container
`Quote ( text )`	Text