I would like to know on how you create multiple currencies in report painter. We have a requirement
whereby we have 3 different columns:
Current Year (Actuals) ---> Exchange rate Type X
Prior Year (Actuals)
Plan Current Year -
> Exchange rate Type Y
My question is how can i create a report that will enable me to prompt for exchange rate of Actuals and Plan data as we would like the user to enter different exchange rate type for actual & plan.
Appreciate your help.