Incorrect decimal places

[Former Member]

Hi Gurus,

My requirement was such that i needed to calculate the percentage of a key figure and them both in 2 columns.

eg: in the first column sales is coming up, and in the second column its percentage w.r.t. the total of it.

I have used the setting "Normalize according to next group level result" and with this the output is coming fine but with 3 decimal places whereas the setting present is 1decimal place.

Kindly give your inputs ig you have any?

Regards,

Abhishek Gupta

[Former Member]

Hello Abhishek Gupta,

Have you found any solution or workaround how to change number of decimal places when using "Normalize according to next group level result" KYF option enabled?

Sap note maybe? Any clues?

Regards,

Janek

[Former Member]

Hi,

Change the setting for the key figure 'sales' also to 1 decimal place.

[Former Member]

Hey,

The 'Sales' key figure should have 0 decimal places and its percentage should have 1 decimal place.

Regards,

Abhishek Gupta

[former_member189638]

If you are facing this problem in Query Designer 3.5 then this is how it behaves while using the option Normalize to Result. Even I had faced this problem with the decmal showing upto three places instead of the setting done to two places in the Key Figure properties.