Sum (PEL)

This function calculates the sum of a numeric expression evaluated over a specific scope.

Sum(
   Scope_Expression
   [ , Numeric_Expression ]
 )

Parameters

  • Scope_Expression
    A valid PerformancePoint Expression Language (PEL) expression that returns a scope.
  • Numeric_Expression
    A valid numeric expression that is typically a PEL expression of cell coordinates that returns a number.

Return Value

This function returns the sum of numeric expressions in a scope.

Remarks

If a numeric expression is specified, the specified numeric expression is evaluated across the scope and then summed. If a numeric expression is not specified, the specified scope is evaluated in the current context of the members of the scope and then summed.

When this function is used with a single argument, the PEL compiler can always generate SQL code. When the function is used with two arguments, the compiler cannot generate SQL code.

See Also

Reference

SQL generation for PEL functions

Other Resources

PEL reference