Problem with Key figure display

[Former Member]

Hi gurus,

I have a problem with one of my queries. My scaling factor for Key figures A,B,C is thousand. the values are being displayed in the local curency i.e $. How i display the report in such a way that the scaling factor is displayed as 1000$ and only the numbers are displayed for the key figures ?

Kindly help

Snehith.

[shanthi_bhaskar · Accepted solution]

Use NODIM()

bhaskar

[Former Member · Accepted solution]

Hi Shanthi,

The problem here is that.I have copied the query from another query. The values are displayed fine without the NODIM function being used there, but they are not getting displayed in the new report. Why is that so ? where could be the problem ?

Regards

Snehith.

[Former Member]

hello Snehith,

You can go to your query in query designer > go to query properties > display> (check )display Scaling factor.

this will display a cloumn of scaling factor between row headers and the 1st column of your query and will prevent any currency symbol display in your key figure values.

Hope this helps you.