cancel
Showing results for 
Search instead for 
Did you mean: 

Currency Display in BEx

Former Member
0 Kudos

Hi,

I am running a query using a conversion to USD. The amount is currently being displayed as $ XXX.XX. I would like to display it as XXX.XX USD. Does anybody know how to achieve this in BEx?

Thank you!

CM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

CM,

It is possible to remove the dimension on a value (i.e. make it just a number instead of currency) in Query Editor by creating a formula and choosing NoDim( ). This may or may not be of help but it might be a starting point to convert via some type of script.

Cheers,

Rusty

Answers (1)

Answers (1)

Former Member
0 Kudos

It cannot easily be done in BEx (probably by VB code). It is a global setting in SPRO under the "Set Alternative Currency Display" option.