how to use the result of KF in new formula

[Former Member]

Hello Experts,

I have 2 KF in the bex query here I want New Formula1 as shown below.

New Formula = (KF1 / Total(KF2)).

I tried checking SUMCT, SUMRT functions but couldn't figure out how to achieve this task.

Can anybody tell me how to achieve this??

CHAR1	KF1	KF2	NEW FORMULA1
D001	101	114	=101/446
D002	99	104	=99/446
DB01	1	1	=1/446
EU01	26	30	=26/446
NA01	103	103	=103/446
NA02	42	83	=42/446
ZIN1	11	11	=11/446
Overall Result	383	446

Regards,

Naresh

[former_member195163 · Accepted solution]

Hi,

you can try K1 / SUMCT (K2)

Regards

Giuliano