Skip to Content
avatar image
Former Member

How to hide % sign in query

Hi experts,

This is going to be an easy one for you guys but I cant seems to get it right this time.

I have a query which calculates variance. In the value displayed, it shows the percentage sign, % next to it, e.g. 10%.

However, my user requested this % sign to be removed as it has been described in the column header itself as % Variance.

So, how can I remove the % sign from my query?

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 10, 2008 at 10:56 AM

    Hi Fullham,

    Create a formula and use the NODIM function.

    Hope it helps.

    BR

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 10, 2008 at 11:03 AM

    Go to the query designer and in a formula use Data Function => data without dimension NODIM

    Rgds

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 26, 2008 at 09:47 PM

    OK, you would probably find this funny. I have the reverse problem. I want the % sign to show up in every line. How do I do this?

    Thank you!

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi BI CONSULTANT,

      Have you managed to solve this problem?

      I think %A is not gonna help you.

      Do you have NODIM() function defined in your formula? Remove this and % sign will be displayed in each rows.