Apply Formula Only If Value In Next Row Is Similar With The Previous ROw Else Leave Empty

[Pankaj_G]

Hi Community,

Need some immediate help to get one issue sorted

Pack Id	Price Start Date	End Date	Difference in dates	Status
5	01-02-2021	01-02-2019	01-02-2019	TRUE
5	02-02-2019	24-02-2020	24-02-2020	TRUE
5	01-09-2021			FALSE
18	01-12-2015			FALSE
19	01-12-2015			FALSE
20	01-07-2021	31-08-2021	31-08-2021	TRUE
20	01-09-2021			FALSE

In the above data set I want to create the column by name "Difference in dates" Its manually created in the above image and I wanna apply Row+1 Formula to create a date in that column after minusing one day from the next row of price start date,Second thing if two rows does not hold the same PACK ID then it should leave the Difference In Dates Cell Blank for that row and it should move on to another row.

Exaple in first three row the PackId is same and you can see the Price start date column After Plus 1 row we have got a date "01-02-2019" in Difference In Date Column.

It has left the 3rd row blank in DIfferent in Dates column because the Pack ID for the next row is different.please reach out in case of any confusion

[DanM]

You should be able to use the Multi-Row formula with a combination of selecting the packID to group by and then using a date time difference expression to get the dates. https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Multi-Row-Formula/ta-p...

[Felipe_Ribeir0 · Accepted solution]

Hi @Pankaj_G 

Please take a look at the attached workflow.

[Pankaj_G]

Appreciate The Efforts And Support Guys, Got What I was Looking For.Thanks to both of you