Help with Allocation
We have a scenario where we have to allocate our budget data depending on last year actual. The values should be allocated in same proportion as it was in actual.
Is there a way where system will calculate the percentage allocation from last year actual and perform allocation using that percentage.
Nilanjan Chatterjee replied
As you said, you want to allocate budget data depending on last year actual. You can have something like:
*FACTOR=USING / TOTAL
*DIM Category WHAT=BUDGET; WHERE=<<<; USING=ACTUAL; TOTAL=<<<
*DIM TIME WHAT=%YEAR%.TOTAL; WHERE=BAS(%YEAR%.TOTAL); USING=BAS(%YEAR%(-1).TOTAL); TOTAL=<<<
This is just an example. You might need to modify it based on the structure of the application.
Hope this helps.