I'm trying to work on logic where I'm expecting below output Input : InvoiceJanFebMarVarianceF009AD87127295.239098.4090-3033.81G00XY7619558.3919558.3919558.39-272.457 Output: InvoiceJanFebMarVarianceF009AD87127295.236064.6030-3033.81G00XY7619558.3919558.3919285.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??

Multi field formula

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

Workflow

Developer

Tips and Tricks

Common Use Cases

Help

Accepted answers

Ladarthure

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!

sample.yxmd

All comments

JosephSerpis

Hi @SuhailPasha07 I would use a multi field tool.

Multi_Field.yxmd

Ladarthure

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!

sample.yxmd

SuhailPasha07

Thankyou !! It worked 🙂

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703