How to get Previous month value in calculation

[mohini7]

Hello All,

i have a list report, in i


Period        Network    WPG                           WIG
---------    -----           -------------                ------------
2009-06   XIO   154,015,334   67,863,564
2009-07   XIO   154,744,222   64,475,495
2009-08   XIO   143,432,417   69,582,847
2009-09   XIO   154,528,535   72,613,258


how can i calculate PPO

calculation formula is  (WPG - WIG) / Previous Month WIG * 30

for example: 2009-09  ppo will be  (154,528,535 - 72,613,258) =  81,915,278
               then 81,915,278/ 69,582,847 = 1.177
               1.177 * 30 = 35.317


so here the tricky thing is how to get previous month WIG value in the calculation, i have tried much time, please i need another brain to work on

Please Help me

i great full to all of you

thanks in advance

mohini

[mohini7]

Any one please help me

any ideas at least please


Mohini

[mohini7]

is it possible at least

please

mohini

[mohini7]

Can Any One please any ideas.............

[mohini7]

Please any ideas

Thanks in advance

[vinu]

Hi

just try with below thought.

Create one calculated data item to get Previous month WIG data and divide with that.

last month WIG = If (period=ADD_MONTHS(sysdate,-1)) then 'WIG' else '0'

Thanks,
Venu

[bloggerman]

Ideally, there should be another column which has the previous month number in it loaded through ETL process.

Else, a workaround could be to build a separate query and join it with the existing main query. You can join such that the previous number comes at the same row.