Calculation issue with percent function and boolean functions

[Former Member]

Hi everybody,

I have a problem with a calculation of formula in the query designer. I want to calculate a percent keyfigure which calculate like this:

(Boolean operator)*10%A100 = 10 with out the the percent symbol.

10%A100 = 10 % with percent symbol.

Is it possible to solve this problem an to get the percent symbol with the first formula.

Regards

Ali

Edited by: Ali Hamoudi on Jul 1, 2009 9:40 AM

[Former Member · Accepted solution]

Hi

Make a CKF1: (Boolean)*10 (properties = hidden)

Make a second CKF2: CFK1A%100

Success,

Udo

[Former Member · Accepted solution]

Thanks Udo,

that solved my problem. Could you tell me how to get the % symbol in every cell of my table?

[mansi_dandavate · Accepted solution]

I guess its not possible to get it in every cell... Just display it in the description of the column..

[Former Member · Accepted solution]

That is not possiblel through SAP Query way. For that you will have to write a Excel macro.

- Danny