Free Trial

Alteryx Designer Desktop Discussions

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

Is it possible to create a new column with a formula referencing the row below?

CDIns
8 - Asteroid

I need to add a formula to my dataset, however, I need to reference the record below. Example would be creating a new column in row 1 that is using the value in row 2 to calculate the change? Sorry if this has been answered already. 

3 REPLIES 3
OTrieger
12 - Quasar

@CDIns 
You should be able to do it with a Multi Row Formula tool

CDIns
8 - Asteroid

Thanks for the heads up! I will give that a shot. 

OTrieger
12 - Quasar

Cool

Labels
Top Solution Authors