Hi Community,
I've built a WAC inventory costing workflow using alteryx.
1st Multi Row Formula
I want to compute first running value . But part of expression is linked with 3rd Multi Row Formula. "[Row-1:Average Cost]" part in the below expression is coming from the 3rd Multi Row Formula.
Expression :
IF [GL Entry No] = 1
THEN [QTY transfer cost]
ELSEIF [Source Code]="SALES"
THEN ([Row-1:Running Value] + ([QTY transfer] *[Row-1:Average Cost]))
ELSE [Row-1:Running Value] + [QTY transfer cost]
ENDIF
2nd Multi Row Formula
[Row-1:Running QTY] + [QTY transfer]
3rd Multi Row Formula
IF [GL Entry No] = 1
THEN [Cost per unit]
ELSEIF [Source Code]="PURCHASES"
THEN [Running Value] / [Running QTY]
ELSE [Row-1:Average Cost]
ENDIF
Issue
The expected result from the first multi-row formula is not coming as I believe the reason is the interdependence of the first multi-row formula tool with the third multi-row formula in my Alteryx workflow.
sample calculation.xlsx shows the manual calculation and expected result from the Alteryx. Please anyone help me to solve this problem.
