Is there an option in Query Designer ...

[Former Member]

Hi Gurus,

Is there an option in Query Designer to remove the $ sign from the dollar amount. If so, please provide the info where it is? I will assign points.

Rgds,

[nikhil_chowdhary2 · Accepted solution]

Hi,

You can create formulae on your keyfigures with the function NoDim().

Create new calculated key figures on your existing key figures and within them just use the formula NoDim(KeyFigure).

Then hide your original key figures.

Hope this helps,

Regards,

Nikhil

[Former Member]

$ sign? if you are displaying currency type you should see USD not $, this case is solved with NODIM function. Are you using text field or numeric field?