Solved

if the result is >0 allocate it to Next Year

  • 3 July 2023
  • 3 replies
  • 73 views

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

 

icon

Best answer by Nathan 3 July 2023, 22:56

View original

3 replies

Userlevel 6
Badge +10

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 +10

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. 

Reply