Referencing a Cell with Parent Group Reference as an Expression
You can also specify the referenced group with a JavaScript expression. The JavaScript expression should be prefixed to the expression string with an '=', as shown below:
$company['state:=iif($type == "T", $state, $province)']
The syntax of the iif function used above is CALC.iif(logical_test, value_if_true, value_if_false).
See Also
Referencing a Column With Expression Filtering, for another use of expressions.
CALC.iif(logical_test, value_if_true, value_if_false), for more information about the iif syntax.
| << Referencing a Cell with Absolute Parent Group Reference | © 1996-2013 InetSoft Technology Corporation (v11.5) | 3.7.5 Special Functions >> |