Forum Discussion
Issue with Formulas - When Multiple Rows Similar Rows Exist
Hi agraca75 ,
Thanks for the update.
To avoid hardcoding and reduce errors, you can use a reference table with From and To dates for each fiscal month. Then, map your data against this table by matching each date to the corresponding From-To range to determine the fiscal month dynamically.
This approach is easier to maintain, as you only need to update the table when there are changes in the fiscal calendar.
Thank you!
Community SupportHi agraca75 ,
The issue is due to working days being calculated per row, which causes double counting when the same incident has multiple rows in the same period.
I reproduced your scenario with smaple data based on your requirement:
To fix this, you can follow these steps:
- Combine all rows for the same incident instead of treating them separately
- Work at the date level (expand each Start–End range into individual dates)
- Remove weekends (and holidays if needed)
- Make sure the same date is not repeated for the same incident (remove duplicates)
- Finally, count the remaining dates per incident
This way, each day is counted only once and the total will be correct.
Output: I have attached the screenshots below showing the expected result
Thanks.