This is my requirement. We need to project the budget values of next year using current year actuals incremented by some percent.We get the year for which the budget values are to be calculated and percent of increase using data manager prompt and I tried the following allocation and logic.But was not able to finish it.
>*DIM TIMEINWEEK WHAT=BAS(%BUDYEAR%(-1).TOTAL);WHERE=BAS(%BUDYEAR%.TOTAL)
>*DIM CATEGORY WHAT=ACTUAL;WHERE=BUDGET
The above logic returns an error and when I replace %percent% by 2, %budyear%(-1).total is multiplied by 2 and allocated to all base members of %budyear%.total
I tried this logic even
where nextyear is a property in timeinweek, which stores the time period to store. For example 2007.jan will have 2008.jan in nextyear property.
Any help will be appreciated.
Edited by: kranthi kumar on Oct 7, 2008 8:46 PM