Showing results for 
Search instead for 
Did you mean: 

Calculation issue with percent function and boolean functions

Former Member
0 Kudos

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.



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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos


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

Make a second CKF2: CFK1A%100



Former Member
0 Kudos

Thanks Udo,

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

Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

- Danny

Answers (0)