Forum Discussion
Weighted Average
Hi I'm trying to calculate weighted average for some data I have. Below is sample of the data. Product Month Stock Sold Stock/Sold Prod 1 JAN 5000 4800 1.041667 Prod 2 JAN 1...
Ashish_Mathur
Super User
Super UserHi,
I am not sure of what you want. Try these measures:
St = sum(Data[Stock])
So = sum(Data[Sold])
WA = divide([St],[So])
Hope this helps.