Skip to Content
Jan 18, 2018 at 03:20 PM

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!!!