EVAL





This function calculates an expression within a certain grouping.

This is a legacy function, it is available for compatibility with the earlier platform versions. We recommend that you use the EvalExpression function instead.

This function has the following parameters:

  • Expression. A string that contains an expression to be calculated.
  • Grouping. A string that contains a name of a grouping where an expression is calculated. If the parameter value is a blank string, the calculation is performed in the context of the current grouping. If the parameter value is Overall, the calculation is performed in the context of the grand total. In other cases the calculation is performed in the context of the parent grouping with this name. 
  • Calculation type. A string that contains the calculation type. If the parameter value is Overall, the expression is calculated for all the records of the grouping. If the parameter value is Grouping, the values are calculated for the current group record of the grouping. 

SUM(Sales.SumTurnover)/EVAL("Sum(Sales.SumTurnover)", "Overall")

In this example the result is the ratio of the sum of the grouping record by the Sales.SumTurnover field to the sum of all composition records by this field.


Comments
0
Add comment