how to display the percentage in query when the it is smaller than 0.05%?

[Former Member]

when i added a fomular in rows or columns struct with content 0.05 A%1,I can only got the result

0.00%.please tell me how to solve the problem ,thank you very much

Edited by: zhen-susie on Apr 1, 2009 11:28 AM

[Former Member]

我也有这种情况，无法解决，不过我是小于0.4%，比如0.33，都显示成0.00%了，如果有解决方法通知我，楼上说的几个方法我都检查过了，没有问题，还是这样，感觉应该是sap的%和%A的bug，是不是要打补丁？

[Former Member]

Hi,

In KF additional properties have you check 'Key Figure with Maximum Precision' ? How many decimal ?

[Former Member]

Hi,

Change the KF property of max precision. I guess this will help.... Also in the query property you can change the number of decimal places displayed....

Regards,

Godhuli

[former_member188325]

Use this formula : 0.05 %A 100

and set number of decimal places to 0.00 in the properties of the formula.

[Former Member]

Dear Zhen,

Please check these :

1. Multiply the formula with something so that you can get enhanced values for everything and the smaller numbers can show you the correct data.

2. Please check the decimal places which can be shown for that formula and make it to 4 or 5 digits this may help you to find the solution.

3. If its a basic key figure on which you can try changing the kF properties , but i guess you will not find a solution in this fashion.

Let me know if you still face this issue.

Regards,

Dennis.