Average Calculation from Actual to Plan

[venkata_singanamala2]

Hi all

I have a requirement of  Average calculation from  Actuals to plan.I am looking TMVL function  to calculate and write to the Plan category in data base and I  can do with using fixed year and periods but not dynmic selections, Looking for your inputs / guidence and application model is YTD and Periods were JAN to DEC.

Ex:

Jan

Act 1       Actuals   $ 1000

Average Calculation =  Value/no of Months   i.e.  = 1000/1 = 10000

Feb

Act 1       Actuals   $ 3000

Average Calculation =  Value(Jan+Feb)/no of Months   i.e.  = 4000/2 = 2000 

Appreciated your help

Thanks

Ramana

[venkata_singanamala2]

Hi Nilanjan

Thank You So Much for your Reply and I have found TMVL code to use and currently it is in testing process . But I will use your code also and test. I think your valuable Information  is also leading towards soulution.

Once Again , Thanks you very much for help/tips/code

Thanks

Ramana

[Former Member]

Hi Ramana,

You need to take the YTD value of a particular month and divide it by the MONTHNUM property of the time period.

*XDIM_MEMBERSET TIME = %TIME_SET%
*XDIM_MEMBERSET MEASURE = YTD
*SELECT(%MON%, "MONTHNUM", "TIME", "ID = '%TIME_SET%'")
*WHEN TIME
*IS *
   *REC(%VALUE% / %MON%, <mention the destination>)
*ENDWHEN

Hope this helps.