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.4) 3.7.5 Special Functions >>