Alteryx Designer Desktop Discussions

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

Formula Question - subtract first record

MarkA
6 - Meteoroid

Hi,

 

I am new to Alteryx. 

 

I am trying to take a column of data and subtract only the first record from every subsequent record - then create a new column with result.  Is this possible?


Thanks,

 

Mark

2 REPLIES 2
tcroberts
12 - Quasar

It sounds like you want to use the Append Field Tool to your data to add the results of a Summary Tool.

 

I've attacked a screenshot and a sample workflow below, let me know if this helps.

 

subtractfirstfromall.PNG

 

Cheers!

MarkA
6 - Meteoroid

Thanks so much, it worked!

Labels