I'm trying to work on logic where I'm expecting below output
Input :
Invoice | Jan | Feb | Mar | Variance |
F009AD871 | 27295.23 | 9098.409 | 0 | -3033.81 |
G00XY76 | 19558.39 | 19558.39 | 19558.39 | -272.457 |
Output:
Invoice | Jan | Feb | Mar | Variance |
F009AD871 | 27295.23 | 6064.603 | 0 | -3033.81 |
G00XY76 | 19558.39 | 19558.39 | 19285.94 | -272.457 |
If you notice I'm trying to remove the variance from the last month value.
Can anybody suggest how this can be implemented in Alteryx??
Solved! Go to Solution.
Hi @SuhailPasha07 I would use a multi field tool.
hi @SuhailPasha07,
if you want to substract only to the last filled value, you should transpole and then use a multi-row formula, here is a sample workflow with your data, tell me if it helped!
Thankyou !! It worked 🙂