Skip to Content
avatar image
Former Member

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

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

beispiel.jpg (46.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 20, 2016 at 05:01 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 19, 2017 at 08:54 AM

    Thanks for your answer. We had the same awareness.

    Kind regards

    Dejan

    Add comment
    10|10000 characters needed characters exceeded