cancel
Showing results for 
Search instead for 
Did you mean: 

how to use the result of KF in new formula

Former Member
0 Kudos

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??

CHAR1KF1 KF2NEW FORMULA1
D001101114=101/446
D00299104=99/446
DB0111=1/446
EU012630=26/446
NA01103103=103/446
NA024283=42/446
ZIN11111=11/446
Overall Result383446

Regards,

Naresh

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi,

you can try K1 / SUMCT (K2)

Regards

Giuliano

Answers (1)

Answers (1)

Former Member
0 Kudos

just create a new formula and

1. drag & drop KF1

2. put a '/' sign

3. drag & drop KF2

Former Member
0 Kudos

Here I dont need the KF1/KF2.

What I need here is KF1/Result of KF2.

Former Member
0 Kudos

ok, my bad

could you work with 2 structures (1 in the rows and 1 in the columns)? 'cause then you could use cell definitions and create a help cell containing your "total" value