on 10-10-2008 2:50 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try :
( KF1 / Sumct(KF2) ) * 100.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.