Question { IBM, 7663 }

In one of my report i have one data item sales_amount. If this report is run by one user from india so the sales_amount should be display in indian repees(Rs.) format, if USA user then in dollers($), if UK user then In Pounds.Hou can i achive this? Please answer me.

Answer

The Best Way is to create a table based on Current day conversion values and use this table for calculation with the "Sale Amount".

This table contains locale as one columns and conversion amount as another columns.

Locale Rate
------ ----
Usa 64
Uk 85
Rupee 1
China 3 ...etc

Use the account.Userlocale session parameter to get the user locale and multiply with 'Rate' column amount.