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,