Sum
Use this function in an equation to calculate total values for a symbol or group of symbols that do not roll up to a specific parent.
In a hierarchy, it is easy to calculate the sum of all child symbols of a parent. However, you may find the Sum function useful to calculate the total of a series of symbols that do not roll up to a specific parent. All symbols must have the same weight (positive, negative, or zero).
Do not confuse the Sum function with the WSum command:
| Function | Description |
|---|---|
To calculate total values for a symbol or group of symbols that do not roll up to a specific parent, when all symbols have the same weight. |
|
To calculate total values for a symbol or group of symbols that do not roll up to a specific parent, when all symbols do not have the same weight. |
Syntax:
SUM (Value1[,Value2][,Value3])
where:
- Each Value is the name of a NUM list variable, or a numeric value or expression that evaluates to a number.
Syntax example:
SUM (Var1, Var2, Var3)