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 |
|---|---|
Sum | 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. |
WSum | 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. |
where:
- Each SymName is a symbol from the dimension corresponding to the calculation type currently in effect. You can also use pound signs ( # ) to specify the number of symbol levels in the hierarchy. Specify symbols containing only numeric values.
- Structure is a range of symbols.
Note: To specify a range of symbols, enter the first and last symbols in the range, separated by a colon. For example, A0601:A0612.
Each Value is the name of a NUM list variable, or a numeric value or expression that evaluates to a number.