Forum Discussion

heitorodriguess's avatar
heitorodriguess
Regular Visitor
5 years ago

Weighted average price over the time | Recursive Measure

Hi everyone,   I have a table that summarizes my data per product type, date, quantity purchased, average price of purchasing, quantity sold, average price of sales and quantity balance. I would li...
Need Help
lbendlin's avatar
lbendlin
Super User
5 years ago

What is the formula for G9?  Fx -Bx is the previous balance, so F12-B12 is the same as F11 ?

  • heitorodriguess's avatar
    heitorodriguess
    Regular Visitor
    5 years ago

    Hello lbendlin 

    The general formula would be the following:

     

    [(Balance - QTY Pur) * Previous Measure Value for that Item + (QTY Pur * AvgPur)] / Balance

     

    For G9 as there is no previous measure value for Item B, would be only (QTY Pur * AvgPur)] / Balance:

    (200*25,31)/200=25,31

     

    Fx - Bx is equal the previous balance only in case there is no QTY Sal

     

    I hope now it´s more clear.

    Thanks in advance!