Sorry, but your description is absolutely unclear! And the attached screenshots are unreadable due to the small size. If you want to get an answer, please start again - and with clear screenshots.
Allocation calculation is not illustrated on the screenshot.
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET FUND_CTR = BAS(3371AA_BPC)
*XDIM_MEMBERSET TIME AS %IN_TIME% = %TIME_SET%
*XDIM_MEMBERSET TIME AS %TIMEMTH% = 01,02,03,04,05,06,07,08,09,10,11,12
*XDIM_MEMBERSET DATASOURCE = BW,INPUT
*XDIM_MEMBERSET FUND = BAS(RCN_VOTE)
*XDIM_MEMBERSET PAA = BAS(ALL_BPC)
*XDIM_MEMBERSET CMMT_ITEM <> CI_NA
*XDIM_MEMBERSET SCENARIO = SC_0
Category Members
ACTUALS for calculation
Storing in FORECAST
user is selecting the year the member value is ID 2015.00
Hi Vadim
I am attaching higher screenshots
Ability to in year forecast at the year level. Planning system should perform a breakdown allocation to a period level using three year average to distribute to the period.The three year average is by cost center
So they want to allocate current year forecast based on last 3 years of actuals. capture4.jpg captures on the allocation part.
They want to take 3 years of actuals. average them . take the distribution percentage and multiply it to the respective month and cc
So for example: Cost Center ABC for January the current forecast is $1000
Actuals for
Year 1 Jan is $1000 and year total is $12000,
Year 2 Jan $1100 and year total is $13200,
Year 3 Jan is $1050 and year total is $12600
Average total of 3 years is $12600 (Capture 2)
Average total of January is $1050
Distribution percentage of Jan is $1050/$12600 = 0.08333 (Capture 3)
This is the percent they want the current Forecast of Jan $1000 to be multiplied with and stored so it will be current forecast $1000 * (1+.08333) = $1083.33 for Jan.
Samething has to be done for all of the months .
Add comment