Help With Weighted Average - Qlik Sense

[stephen_schrims]

PLEASE CAN YOU HELP. I NEED TWO MEASURES:

1)   ONE TO BE ABLE TO CALCULATE IGNORING SELECTIONS MADE TO ASSESSMENT ID.

2) ONE TAKING INTO ACCOUNT ALL SELECTIONS MADE

Assessment ID	Product Value	Number of Products Deep	Number of Products High	Number of Products Wide	Case Value
1	0.1	6	1	2	1.2
2	0.2	8	1	1	1.6
3	0.3	7	1	2	4.2
4	0.2	10	1	4	8
5	0.15	6	1	1	0.9
				TOTAL	15.9

CASE VALUE = Product Value x Number of Products Deep x Number of Products High x Number of Products Wide

WEIGHTED AVERAGE  = SUM(Case Value) / COUNT (Assessment ID)

WEIGHTED AVERAGE  = 15.9 / 5 = 3.18

[sunny_talwar]

Are these needed in KPI Object? Try these:

1) =Sum({<[Assessment ID]>} [Product Value] * [Number of Products Deep] * [Number of Products High] * [Number of Products Wide])/Count({<[Assessment ID]>}DISTINCT [Assessment ID])

2) =Sum([Product Value] * [Number of Products Deep] * [Number of Products High] * [Number of Products Wide])/Count(DISTINCT [Assessment ID])