How to calculate a sum of data in column as and when it is added in row

[ShaileshDevadiga]

Hi,

For below I would like to run similar formula in Alteryx for Average Purchase Price and Average VVWAP
Formula says that average price should be sum of value divided by sum of quantity. So sum will keep on adding as and when we add qty and value on daily basis
For example on 20th March , it will be 100/10 = 10, then next day it will (100+200)/(10+20) so accordingly it will keep increasing like (100+200+400)/(10+20+30)
At same time I need to be careful that Sum of that column is also calculated at bottom of column

Attached Input and formula

[PhilipMannering · Accepted solution]

Hi @ShaileshDevadiga 

Does this do what you need?

[ShaileshDevadiga]

Thanks Philip, spot on, that;s what I was looking for, I shall same Run Total to calculate Average VVWAP column

[ShaileshDevadiga]

@ Philip Mannering - Thanks RunTotal works for Average Purchase price, but for Average VWAP it has different formula i.e =iferror(average(vvwap column)
So currently vwap column shows 2 for each day so average should be 2.