on 06-13-2012 1:31 PM
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
Hi,
you can try K1 / SUMCT (K2)
Regards
Giuliano
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
just create a new formula and
1. drag & drop KF1
2. put a '/' sign
3. drag & drop KF2
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
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.