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

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.

FILTER (Entities TempEnt; =="AAA")                                    
...
END FILTER