Skip to Content

Decimal places of custom calculation

Dear Experts,

I am using SAP design studio 1.6 and Bex query as a data source. I have a data source which has some measures, say A, B, C.

In Edit initial view of the data source (Design studio interface), I calculated sum (S) of the three measures (S = A + B + C). I did this by selecting the three provided measures, right clicking and using the “Add” function.

After this, I selected A and S , right clicked and selected “Percentage Share” to find the Percentage (P) of “A”. This gave me the percentage up to three decimal places. I want to set P up to one decimal place. When I right click P, there is no option of “Decimal Places”.

I have to display the P column” (Percentage of A) in a crosstab up to one Decimal place.

How can I achieve this? DO I need to write some scripts?

Please help. Any help will be greatly appreciated!!!

Thanks!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 19 at 05:45 AM

    I also have DS 1.6 SP5 and I can see the decimal places option:

    capture.png

    Add comment
    10|10000 characters needed characters exceeded

    • I am able to reproduce the scenario. Looks like it is a behavior by design. I have not tried the same in Lumira 2.1 yet, but I think you can raise an idea for the same.