In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Weighted Average Cost computation in Alteryx

Buddhi_DB
8 - Asteroid

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.

4 REPLIES 4
Raj
16 - Nebula

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

mark done if solved.

Buddhi_DB
8 - Asteroid

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

Screenshot (6).png

Raj
16 - Nebula

@Buddhi_DB 
please find the zip attached
hope this helps.

Buddhi_DB
8 - Asteroid

Thanks for help. It's working

Labels
Top Solution Authors