Skip to Content
0
Former Member
May 12, 2011 at 05:13 AM

Key figures with currency conversion showing weird values.

20 Views

Hi Experts,

I have a variable screen,

User can key in Target Currency, and Month.

Say,

(Scenario 1) User keys in Target Currency "MYR", and Month "4"

The report will show

Jan| Feb| March| April| May| June| ...

2| 3| 5| 7| 0| 0| 0 ...

This is correct.

(Scenario 2) User keys in Target Currency "USD", and Month "4"

The report will show

Jan| Feb| March| April| May| June| ...

2| 3| 5| 7| 3| 5| 7 ...

This is wrong, should not show figures for month May and onwards.

(Scenario 3) User keys in Target Currency "SGD", and Month "4"

The report will show

Jan| Feb| March| April| May| June| ...

1| 2| 3| 4| 0| 0| 0 ...

This is correct.

*In the infoprovider, the key figure is tied to currency "MYR".

In developement system, i replicated the exchange rate table, and the problem (Scenario 2) is solved.

In test system, i replicated the exchange rate table, and the problem (Scenario 2) is still there.

I am not sure what is happening here.

Please could you please kindly advise.

Thanks.

Tee