Uses the CONCAT function and expands an expression in an expression macro to concatenate multiple fields. %OPR_CONCAT% creates calculations similar to the following expression:

FieldA || FieldB || FieldC...

Uses the CONCAT function and expands an expression in an expression macro to concatenate multiple fields, and adds a comma delimiter. %OPR_CONCATDELIM% creates calculations similar to the following expression:

FieldA || ", " || FieldB || ", " || FieldC...

Uses the IIF function and expands an expression in an expression macro to evaluate a set of IIF statements. %OPR_IIF% creates calculations similar to the following expression:

IIF(<field> >= <constantA>, <constant1>,
  IIF(<field> >= <constantB>, <constant2>,
    IIF(<field> >= <constantC>, <constant3>, 'out of range')))

Uses the SUM function and expands an expression in an expression macro to return the sum of all fields. %OPR_SUM% creates calculations similar to the following expression:

FieldA + FieldB + FieldC...