Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to subtract the second row from first in several columns

FabioP
8 - Asteroid

I have this situation: 

FabioP_0-1591885449758.png

 

I'd like to subtract the line 4 from line 3. In Excel is =B3-B4.

I don't know what tool is better to do this.

 

Could some one help me with this?

3 REPLIES 3
MichaelLaRose
10 - Fireball

Hi @FabioP 

 

You are going to need to use the multi-row formula tool.

 

Best,

Michael

fmvizcaino
17 - Castor
17 - Castor

Hi @FabioP ,

 

The multi-row tool is commonly used to subtract values relatively, but since you have a dynamic number of months, we need to create an automatic way of subtracting everything. Image and workflow attached.

fmvizcaino_0-1591886270358.png

 

Best,

Fernando Vizcaino

 

FabioP
8 - Asteroid

I tried!

But I don't how configure or create the formula.

Labels