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.

FAQs

Frequently asked questions can be found here.

Contact

You may contact the Valsight Customer Support via:

+49 30 46799042

support@valsight.com

Availability: Mon-Fri *, 9 AM to 5 PM (Berlin, Germany) .

_{*Except Public holidays in Berlin, Germany.}