Open breaks (Month End)

[rshetty]

Hi All,

Could you please help with the below issue. 

BRK_ID	BRK_CRE_DT	CLSE_DT	STS
1	2022-02-19	8/1/2022 7:15	Open
2	2022-05-22	8/1/2022 7:15	Closed
3	2022-06-18	9/1/2022 8:05	Closed
4	2022-06-23	9/2/2022 5:44	Open
5	2022-07-03	9/8/2022 22:17	Closed
6	2022-07-09	8/2/2022 22:14	Closed
7	2022-07-18	8/2/2022 22:14	Open
8	2022-08-10	9/2/2022 6:01	Closed
9	2022-08-13	9/16/2022 16:46	Closed
10	2022-08-18	9/8/2022 21:21	Closed
11	2022-08-18	9/8/2022 21:21	Open
12	2022-08-30	10/23/2022 6:01	Closed
13	2022-09-13	10/6/2022 22:18	Closed
14	2022-09-13	10/23/2022 6:01	Open
15	2022-09-17	10/6/2022 16:19	Open
16	2022-09-19	10/26/2022 12:02	Open
17	2022-10-14	10/26/2022 13:05	Closed

I want see below Break ID as Open breaks for the month of August. The logic is to show breaks created for the August( excluding open and closed in August) month plus carried forward open breaks from previous month plus breaks closed after August month. 

3
4
5
8
9
10
11
12

Any help will be much appreciated.

Thank you

Rishi

[Felipe_Ribeir0]

Hi @rshetty 

One way of doing this

[rshetty]

Thank for your swift response. Sorry I was not clear before. I need this for all three months and should be dynamic ex, Nov and Dec it should auto pick these values based on the formula or flow so that this flow can be added to a Schedule.

Thank you

Rishi

[Felipe_Ribeir0]

Hi @rshetty 

What about this version, with this one you can get the response for all months inside your dataset (column ReferenceMonth), just filter which one you want.

[Felipe_Ribeir0 · Accepted solution]

Hi @rshetty 

It worked?

If yes, please accept it as a solution :)

Thanks!