Skip to main content
Skip table of contents

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.