1-X Pattern
Due to the multi-dimensional calculation a formula like "1 - 'Node'" does not lead to the result you may expect, but to the equivalent of 1 - ROLLUP('Node'). You probably meant to use:
CODE
ADDEACH(‘A' * -1, 1)
Example
A=
Year | Product | Value |
---|---|---|
2018 | A | 0.1 |
2019 | B | 0.2 |
A * -1 =
Year | Product | Value |
---|---|---|
2018 | A | -0.1 |
2019 | B | -0.2 |
ADDEACH(‘A' * -1, 1) =
Year | Product | Value |
---|---|---|
2018 | A | -0.1 + 1 = 0.9 |
2019 | B | -0.2 + 1 = 0.8 |
See ADDEACH for more examples.