Skip to Content
author's profile photo
Former Member

Report shows $ symbol , How to remove $ Currrency

Hi

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

Regards

ramu

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Posted on Apr 14, 2011 at 05:38 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • author's profile photo
    Former Member
    Posted on Apr 14, 2011 at 05:18 AM

    Hi Ramu,

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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 05, 2011 at 11:39 AM

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

    Add comment
    10|10000 characters needed characters exceeded