Skip to Content
0
Former Member
Sep 08, 2011 at 09:30 AM

Foreign Exchange Confusion

17 Views

Hi,

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.

Cheers,

Lip Chean