Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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])