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
Solved
if the result is >0 allocate it to Next Year
+2- Wallflower
Best answer by Nathan
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
Rocco
+12- Employee
- Answer
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
+12- Employee
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.