Hi guys,
I have the following:
Note: in DATE2 DAY WEEKDATE, taking away the weekends.
I couldn't use summarize tool to group the id as I have different dates and wouldn't add the correct criteria. I tried using multi-row formula but not giving me the result I needed.
Multi-row formula used:
IF [DATE2 DAY WEEK DATE]=[Row+1:Date] THEN [Days]+1 ELSE [Days] ENDIF
| INPUT | | | | | | OUTPUT | | | | |
| ID | TYPE | DATE | DATE2 DAY WEEKDATE | DAYS | | ID | TYPE | DATE | DATE2 DAY WEEKDATE | DAYS |
| 3865 | Holidays | 02/07/2024 | 03/07/2024 | 0.5 | | 3865 | Holidays | 02/07/2024 | 03/07/2024 | 6.5 |
| 3865 | Holidays | 03/07/2024 | 04/07/2024 | 1 | | 3865 | Holidays | 30/07/2024 | 31/07/2024 | 1 |
| 3865 | Holidays | 04/07/2024 | 05/07/2024 | 1 | | 3929 | Holidays | 04/07/2024 | 05/07/2024 | 2 |
| 3865 | Holidays | 05/07/2024 | 08/07/2024 | 1 | | 3929 | Holidays | 19/07/2024 | 22/07/2024 | 1 |
| 3865 | Holidays | 08/07/2024 | 09/07/2024 | 1 | | 3929 | Holidays | 23/07/2024 | 24/07/2024 | 2 |
| 3865 | Holidays | 09/07/2024 | 10/07/2024 | 1 | | 3929 | Holidays | 30/07/2024 | 31/07/2024 | 1 |
| 3865 | Holidays | 10/07/2024 | 11/07/2024 | 1 | | | | | | |
| 3865 | Holidays | 30/07/2024 | 31/07/2024 | 1 | | | | | | |
| 3929 | Holidays | 04/07/2024 | 05/07/2024 | 1 | | | | | | |
| 3929 | Holidays | 05/07/2024 | 08/07/2024 | 1 | | | | | | |
| 3929 | Holidays | 12/07/2024 | 15/07/2024 | 1 | | | | | | |
| 3929 | Holidays | 19/07/2024 | 22/07/2024 | 1 | | | | | | |
| 3929 | Holidays | 23/07/2024 | 24/07/2024 | 1 | | | | | | |
| 3929 | Holidays | 24/07/2024 | 25/07/2024 | 1 | | | | | | |
| 3929 | Holidays | 30/07/2024 | 31/07/2024 | 1 | | | | | | |
