I've done a sample WAC computation using excel.
A:N columns are from movement report.
Key field
Column G - Trans Qty (That's the during the year QTY movement)
Column B- Type ( Sales order/Purchases order/Revaluations,etc)
Column I - Transaction Cost ( QTy movement related cost)
Column L - Average cost
G3 cell has the opening QTY as per last year valuation report
L3 cell has the opening unit WAC average cost as per last year valuation report.
R:T has my compuation.
Key columns
R-Cumulative value
S-Cumulative QTY
T-WAC average cost
There first line ,is opening value and QTY. R3 cell is =G3*L3 and S3 is =G3 and T is =L3
from row 4 to towards to end. R formula is "=IF(B4="SO",R3+(G4*T3),R3+I4)" and S is "=S3+G4" and T is "=IF(OR(B4="PO",B4="RV"),R4/S4,T3)"
How can I do my computation like this in alteryx
I tried to do this using Multi-Row Formula Tool. But I was not success.
