if the result is >0 allocate it to Next Year

  • 3 July 2023
  • 3 replies

Userlevel 2
Badge +2
  • Budding Pigmenteer
  • 6 replies

Hello everyone,


  • What I would like from the formula:

if the result i bigger than 0 allocate it (aggeregate it) to next FY year


The only dimension used is month,

Any Idea is welcome



Best answer by Nathan 3 July 2023, 22:56

View original

3 replies

Userlevel 6
Badge +11

hey Rocco,


you should be able to do something like this:

Basically within a BY you can add/subtract items. Works the same per year.


It would probably be cleaner to do a double time dimension, to show how deferred loss can be accumulated over the future years and from which year that loss comes from


Userlevel 2
Badge +2

Thank you for the answer, 
It is a great answer:)


Userlevel 6
Badge +11

And I should note, it works the same for every dimension in Pigment, they are all ordered by default so a + or - works on all of them.