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:

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.


Was this helpful?

Yes | Somewhat | No