Forum Discussion
Post PatronAverage stock
Community ChampionAGo What Measure(s) do you have right now for the Weighted Average?
Can you explain using your table exactly what are you trying to calculate?
What would those Measures's results be in your sample table?
AGoThere's no measure yet. The calculation from this table is very difficult and must be: (stock quantity*number of days from the date in the line to the next date of product quantity update, in addition to the same calculation done before on the same product)/total number of days selected in the filter.
For example at the 6th line of the table I posted before the result would be: ((120*24)+((120+(-20))*36))/60
60 is the number of days filtered from 01/01 to 01/03
120 is the quantity of the previous step of the product
24 and 36 are the number of days to be weighted for the average
-20 is the stock quantity moved at the considered line
MINDBLOWING for me