Assume that my Application is a YTD application, and Jan is Fiscal Period = 1.
Assuming i have YTD Local Currency in Jan, Feb and Mar of 1000, 1000, 1000;
I have YTD Avg Rate in Jan, Feb and Mar of 1.1, 1.2, 1.3
i would have YTD Group currency in Jan, Feb and Mar of 1100, 1200, 1300
But if i am to derive Periodic values by changing the measures, i would get
PER Local Currency in Jan, Feb and Mar of 1000, 0 , 0
PER Group Currency in Jan, Feb and Mar of 1100, 100, 100
It sounds weird to me that there's growth in Group Currency, when there's no growth in Local Currency.
Can anyone offer a simple explanation? Or maybe something extra needs to be done.
Let me know if more details are needed.