Multi - Row Formula

[BRRLL99]

Hi Team,

I have following input 

ID	STARTDATE	ENDDATE	CMOUNT
615N	20230907	20230908	88
615N	20230908	OPEN	100
616N	20230907	20230908	100
616N	20230908	OPEN	120
617N	20230907	20230908	99

calculation on the basics of

Group by ID

if row no: 2 of STARTDATE is equal to row no: 1 of ENDDATE, then (100 - 88) should be calculated

ID	STARTDATE	ENDDATE	CMOUNT
615N	20230907	20230908	12
616N	20230907	20230908	20
617N	20230907	20230908	99

[niklas_greilinger · Accepted solution]

Hi,

I attached a possible solution for your problem. Is this suitable for you?

Formula:
"IF [Row+1:STARTDATE] = [ENDDATE] THEN [Row+1:CMOUNT]-[CMOUNT] ELSE [CMOUNT] ENDIF"