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
View original
if the result is >0 allocate it to Next Year
Userlevel 2
+2
- Budding Pigmenteer
- 6 replies
Userlevel 6
+11
- Employee
- 169 replies
-
3 July 2023
- 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
Userlevel 2
+2
- Budding Pigmenteer
- 6 replies
-
4 July 2023
Thank you for the answer,
It is a great answer:)
Userlevel 6
+11
- Employee
- 169 replies
-
4 July 2023
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.