WSum
Use this function 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.
With parent/child relationships, it is easy to calculate the sum of all child symbols of a parent. However, you may find the WSum function useful for calculating the total of a series of symbols that do not roll up to a specific parent.
The process of calculating the total of symbols that do not have the same weight is called weighted summation. If the symbol’s weight is negative, the symbol is subtracted from the total; if it is positive, the symbol is added to the total; and if it is zero, the symbol does not affect the total.
Do not confuse the WSum function with the Sum command:
| Function | Description |
|---|---|
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. |
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. |
Syntax:
WSUM (SymName1[Structure], [SymName2, ... SymNameN])
where:
- Each SymName is a symbol whose child symbols you want to add. You can also use pound signs ( # ) to specify the number of symbol levels in the hierarchy.
- Each Structure is the symbol structure that will define a limited or restricted set of symbols.
Syntax example:
NetInv = WSUM (InvT ###)