To calculate a stacked sum, use the following expression:
EvaluateExpression("Sum(AmountTurnover)", , , "First", "Current")
To retrieve a grouping value in this example, use the following expression:
EvaluateExpression("Rate", , , "Previous")
The EvaluateExpression function is calculated based on grouping filters, but not hierarchical filters.
The EvaluateExpression function cannot be applied to a grouping in a group filter of that grouping. For example, you cannot use the EvaluateExpression("Sum(AmountTurnover)", , "Overall") > 1000 expression in the Products grouping filter, but you can use it in a hierarchical filter.
If the last record precedes the first one, it is considered that there are no records for calculating detailed data and aggregate functions.
When interval expressions are calculated for the overall (the second parameter of EvaluateExpression function has an Overall value), it is considered that there are no records for calculating detailed data and aggregate functions.
Next page: LEVEL