Skip to Content
0
Former Member
Jun 16, 2008 at 10:01 AM

Variable Offset

34 Views

Hi Experts,

I am specifying a variable offset -2, for the Variable 0I_FPER , Now I want display the previous periods data

also in query , How can i do that

Eg: Var (0I_FPER) X = 003.2008

X-1 = 002.2008 X-2 = 001.2008

now I want to display like below

X-2 X-1 X

001.2008 002.2008 003.2008

Can any body help me....

Thanks in Advance......

Regards,

Nagamani