Regex Pattern

[Rakshit111]

I have few Deal Id's with Effective Date(ED) and Maturity Date(MD) in number of line items, i have 2 requirements where 1st is fulfilled but in the 2nd one i am struggling with:

1. i need ED = (1 row - MD) which i got from Multi Row formula, but when a deal id get changed, the ED getting equal to MD of last deal id (each deal ID has multiple rows), so that raise the 2nd requirement 

2. So i want to have 1st ED (i.e. 1st row for that deal ID) to be null for each ID , when the Deal ID get changed - so later i can updated the Null values with other dates through formula tool or if possible when ED will null then it will be equal to Issue Date.

I have attached the sample data - with requirement marked in Red.

Thanks a ton in advance :)

[JamesCharnley · Accepted solution]

Hi @Rakshit111 

If I'm understanding correctly, we can actually bypass the second requirement with some extra configuration in the multi-row formula tool. You should be able to tick the check box to 'Group by ID' so the new date isn't being taken from the previous ID. I've attached an example workbook.

[binuacs · Accepted solution]

@Rakshit111 One way of doing this

[Rakshit111]

Thanks a lot to both of you.

It's super helpful