# 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.