Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

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 a 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
    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 a comment
    10|10000 characters needed characters exceeded

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

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.