cancel
Showing results for 
Search instead for 
Did you mean: 

How to Calculate Average on SubTotals

Former Member
0 Kudos

Hi All

I need calculate Average on subtotal result

10

20

30

---

60

---

---

---

Calculation is in this way

10/60 *100 = avg =16.66

Pls share your ideas.

Thanks

Purushottam

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

try to create a CKF with the foll logic:

KF/sumct(KF) *100

here KF stands for the actual KF which contains value 10, 20 and 30 as per your example.

Regds,

Shahsank