Simple multi row formula

[Hamder83]

Hi 

I am loading all customers agreements into my flow.

Lets say one customer gets a new agreement every year.

Then every time i load a new agreement, I want to set end date of the previous agreement to the start date of the new.

ive attached sample data, and how I filled my muti row forumla, but I am missing something...

Thanks in advance,

[atcodedog05]

Hi @Hamder83 

Here is how you can do it.

Workflow:

1. Using sort tool sort by customer, sort start date by descending.

2. Using multi-row formula groupby customer and take previous row start date.

Hope this helps : )

[AngelosPachis]

Hi @Hamder83 ,

Maybe you can use a multi-row formula tool to get the value on the previous row if your dataset is sorted in a descending chronological order.

Grouping on customer ID or customer name will make the multi-row calc restart for each unique customer ID so no need to use an If statement

[Christina_H]

Your formula looks good to me, except for a spelling error at the end!  Change ENIDF to ENDIF

[messi007]

@Hamder83 ,

Please see below :

Attached the workflow,

Regards,