cancel
Showing results for 
Search instead for 
Did you mean: 

Calculate Percentage from the result of another Key Figure

Former Member
0 Kudos

Hello

I want to calculate percentage fro a kf. But wht i want to do is...

I have 2 KFs eg KF1 and KF2.

I did (KF1/ KF2)* 100. but this is not what the users want to see.

they want

(KF1/ Overall result of KF2)*100.

please can someone tell me how can i do this in the Query designer.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hello

One way is to define KF3 as the summation of KF2 with some code in the update rule

LOOP AT I_table

WHERE X = COMM_STRUCTURE-X

AND Y = COMM_Y.

RESULT = RESULT + I_table-KF2.

ENDLOOP.

Then in the query designer you can create the formula you wrote

(KF1/KF3)*100

Rgds

Former Member
0 Kudos

Graeme,

You can do this like this:

Create a new calculated key figure.

Drag in KF1 into the 'detailed view'.

Then goto data fnctions, select 'percentage share'. Drag that in.

Then go to 'data function' drag in 'overall result'. Then finally drag in your key figure you want the overal result for.

In the end you should hve something that looks like:

KFG1 %A SUMGT KFG2.

That should do the trick.

Thanks,

Nick

former_member205352
Active Contributor
0 Kudos

Try :

( KF1 / Sumct(KF2) ) * 100.

Hope this helps.