Weighted Average Cost computation in Alteryx

[Buddhi_DB]

Hi,

I've done a sample manual WAC computation using excel.

I manually computed the Running Value and Running Quantity to get the Average Cost. I need to compute the Running Value, Running Quantity, and then the Average Cost in a similar manner in Alteryx and compare it with the "Trans Whse Avg Cost."

I want to upload the Stock Movement Report and Opening Valuation Report and compute it automatically.

Here's the workflow I built. I computed this using a multi-row formula. The final Running Value should be 2448, but I'm getting a different result. The Average Cost is also incorrect.

I think the issue is  interdependent multi-row formula tools in my Alteryx workflow. Interdependencies where the calculations from Step 2 (Running Value) and Step 3 (Average Cost) depend on each other.

Can anyone help me with this please.

[Raj]

@Buddhi_DB 
formual updated now the value is 2448
find workflow attached

mark done if solved.

[Buddhi_DB]

Hi @Raj , I appreciate your effort. 
But file is not opening. can you send me the .yxzp file.

[Raj · Accepted solution]

@Buddhi_DB 
please find the zip attached
hope this helps.

[Buddhi_DB]

Thanks for help. It's working