community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

Formula Question - subtract first record

Highlighted
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

Alteryx Partner

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!

Meteoroid

Thanks so much, it worked!

Labels