Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Need Help!
I have to calculate Weighted avg where Number and Entity are same:
sum(TC1+TC2+TC3)/Sum(Q1+Q2+Q3)
Number | Entity | QTY | Total Cost | Unit Cost | Weighted Avg |
100 | ROP | 2 | 10 | Total Cost * QTY | Total Cost * QTY |
100 | RUH | 3 Q1 | 20 | TC1 | |
100 | RUH | 4 Q2 | 10 | TC2 | |
100 | RUH | 5 Q3 | 20 | TC3 |
Weighted average in this scenario would presumably be:
Sum(QTY * [Total Cost]) / Sum(QTY)
And would be calculated for whichever dimensions you put in your table / object.