Filter
Use this function to filter the symbols affected by a calculation. A FILTER statement is similar to a WHEN statement, except that the filtering is not confined to the calculation block.
Use this function to:
- specify a DataArea in which to check the filtering condition
- identify condition using operators
- state an operation when the condition is evaluated to TRUE
- allow for filtering condition symbols, since symbols for specified dimensions need not be contained in the calculation block
Syntax:
FILTER (DimName SymName; Condition)
//statements for this Filter
END FILTER
where:
- DimName is a dimension other than the calculation dimension.
- SymName is the name of the symbol in the dimension that holds the filter key value.
- Condition is an expression that evaluates to a TRUE/FALSE indicator (1/0). For a list of valid conditions, see the Is functions.
Syntax example:
FILTER (Entities TempEnt; =="AAA")
...
END FILTER