Table of Contents
Essbase - Consolidation Operator
About
The consolidations operator define the consolidation path and can be used in formulas.
Article Related
List of operator
| Operator | Representation | Description |
|---|---|---|
| + | plus sign representing addition | The default operator. Essbase adds the member to the result of previous calculations performed on members of the branch. |
| – | dash representing subtraction | Essbase multiplies the member by ‑1 and then adds the product to the result of previous calculations performed on members of the branch. |
| * | asterisk representing multiplication | Essbase multiplies the member by the result of previous calculations performed on members of the branch. |
| / | forward slash representing division | Essbase divides the member into the result of previous calculations performed on members of the branch. |
| % | percent sign representing percentage | Essbase divides the member into the sum of previous calculations performed on members of the branch. The result is multiplied by 100. |
| ~ | tilda representing no consolidation | Does not use the member in the consolidation to its parent. |
| ^ | Does not use the member in any consolidation in any dimension. |
