Multi field formula

[SuhailPasha07]

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??

[JosephSerpis]

Hi @SuhailPasha07 I would use a multi field tool.

[Ladarthure · Accepted solution]

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!

[SuhailPasha07]

Thankyou !! It worked 🙂