Dear all, I have several excel formulas that I want to translate to Alteryx. I tried to adopt Multi-row formula to update the row, however, the dependency between each field would cause difference answer after I reapply the formula.
e.g.
| DATE | UNIT_POSITIVE | UNIT_NEGATIVE | MKT PRICE | Unit c/f | Avg price | Amount c/f |
| 12/15/2025 | - | - | 22.00 | - | - | - |
| 12/16/2025 | 60.00 | - | 23.00 | 60.00 | 23.0000 | 1,380.00 |
| 12/17/2025 | 50.00 | (25.00) | 23.00 | 85.00 | 23.0000 | 1,955.00 |
| 12/18/2025 | - | - | 22.00 | 85.00 | 23.0000 | 1,955.00 |
| 12/19/2025 | - | - | 22.00 | 85.00 | 23.0000 | 1,955.00 |
| 12/20/2025 | 5.00 | (8.00) | 22.00 | 82.00 | 22.9390 | 1,881.00 |
but Avg price and Amount c/f are newly created from the original data set
Appreciate if anyone is willing to give a helping hand, thank you so much.
