jassybun
Member
*file is attached*
The green columns actually work, but this isn't the end product that I need, but its a start I guess.
Each event has a start date and end date, and I split up the days (network days minus holidays) but they can only be charged a max of 40 days. The report will only show the charge up to the previous month. So if I run the report in any day in November, I will only see charges prior to November. I run this report once a month.
What I do have working is the count of network days - holidays (I am going to add a few more holidays) separated by month. Underneath are examples of what the data would look like if I ran it in Nov 2017, Dec 2017, and Feb 2018.
There will be more than just 4 rows of data...probably like a few 100 or so, grouped by each facility.
Each line is associated with one unique event number (like a claim number), which isn't in this file, but does exist in each data row. Eventually I will have to add up all of the days for the same facility, for each facility. One facility can have multiple events. The unique facility code is also in the data row, but not in this file. I figure I can find a way to total it later. Any help with this is greatly appreciated.
The green columns actually work, but this isn't the end product that I need, but its a start I guess.
Each event has a start date and end date, and I split up the days (network days minus holidays) but they can only be charged a max of 40 days. The report will only show the charge up to the previous month. So if I run the report in any day in November, I will only see charges prior to November. I run this report once a month.
What I do have working is the count of network days - holidays (I am going to add a few more holidays) separated by month. Underneath are examples of what the data would look like if I ran it in Nov 2017, Dec 2017, and Feb 2018.
There will be more than just 4 rows of data...probably like a few 100 or so, grouped by each facility.
Each line is associated with one unique event number (like a claim number), which isn't in this file, but does exist in each data row. Eventually I will have to add up all of the days for the same facility, for each facility. One facility can have multiple events. The unique facility code is also in the data row, but not in this file. I figure I can find a way to total it later. Any help with this is greatly appreciated.
Last edited:
