Skip to Content
0
Former Member
Feb 28, 2008 at 03:34 AM

Urgent : Difference of two fiscal period

278 Views

Hi,

For one of the reporting requirement I have to calculate the difference between two fiscal period's, which i am able to do using the replacement path variable and working fine for two different months of same period.

For eg ; if i calculate difference between these two values of fiscal period (Variant V9)

period1 = 3.2008 (Dec 2008)

Period2 = 6.2008 (March 2008)

Then result is fine i.e 3

But if i calculate the difference between these two periods :

Period1 = 12.2007

Period2 = 1.2008

Im getting result = 989..........!! In such case my expected result is 1.

Can anyone suggest me what can i do regarding to this calculation or how can i get this, Its very urgent issue.

Thanks & Regards,

Dipika