How can I prevent the currency in a spreadsheet item Design Studio?

[former_member283111]

Hello,

we have a problem, in our query we have deselect the Option of showing the currency. The query does not show the currency in the Report (open in Analysis), but in the spreadsheet in Design Studio every cell shows the currency. Is there any possibility to prevent the currency in the cells?

Has any one a solution ?

beispiel.jpg

[Former Member · Accepted solution]

Hi Dejan,

There is no way you can hide the currencies in a spreadsheet component.

Either you can use Crosstabs and hide the units

OR

Define the measure as a formula with no dim in Bex if you are using BW as data source.

Arun

[former_member283111]

Thanks for your answer. We had the same awareness.

Kind regards

Dejan