We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Discussions

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

Calculate difference between values in a previous and next day.

MaksimBI
6 - Meteoroid

Hi community,

How to calculate the "Difference" field? 

The data is as follows: 

DateValueDifference
01.01.20191000 
02.01.201910055
03.01.201910083

 

The "value" field is cumulative. Difference starts from day 2. Because we don't have data fro 01.01.2019 to compare with .

 

Thank you.

3 REPLIES 3
JohnJPS
15 - Aurora

Hi @MaksimBI 

 

Use the Multi-Row Formula tool: Difference = [Value] - [Row-1:Value]

 

Hope that helps!

John

MaksimBI
6 - Meteoroid

Hi @JohnJPS ,

Thank you, that helped.

RebeccaCurry
7 - Meteor

thanks for posting this question! Exactly what I needed!

Labels