Report shows $ symbol , How to remove $ Currrency

[Former Member]

Hi

My Report shows $ symbol for Amont, How should i remove this $ Currency from Report, Any inputs

Regards

ramu

[Former Member]

According to their Suggestions it was working so i close the Querie

[anshu_lilhori]

Hi,

Go to Query Dsigner-open your query--make one new formula in columns and use NODIM function you will find this under Data functions.

Just put like this NODIM(0amount) this will remove curreny or unit for the keyfigure you want.

Hope it helps.

Regards,

AL

[Former Member]

Hi

Thank you AL,

I tryed with according to AL steps my problem was resolved

Regards

ramu

[former_member211907]

ramu-

I would advise caution. You may be presenting incorrect data if you have the chance of more than one currency in your data. For example... Order "A" is for RS 1,000. Order "B" is for USD $1,000

Total orders would show up as 2,000 , but this value is factually incorrect.

To avoid possible confusion, consider using a currency translation or a currency restriction (in the Units dimension).

Having wonderfully formatted data has no value if the data is wrong.

[Former Member]

Hi Ramu,

You want to do this change at query level or workbook level ??