Unfortunately, I cannot answer that question. i'm only able to create reports based on the callout table. i thought i could create a report that would allow me to write a formula to summarize the information based on the fields in the report.
Qrew LegendIt might be possible using a Formula Query but a whole lot easier for the person who has Admin access to do, using the summary fields on relationships.
Hi Mark,
I'm racking my brain on how to count consecutive business days. I have a staff table and a days table, where days is a child to staff. I need to know if someone has 15 consecutive business days in the child table.
Easiest method would be to leverage the relationship and figure out the date of 15 business days prior and count how many working days that person is staffed after that date. So basically create a formula in your days table for '15 Day Cutoff' and make it a formula-date that subtracts 15 workdays from Todays date. Then in the relationship - summarize the # of days where that person is staff where the date is on or after that cutoff date. Have a formula then evaluate if that number is equal to 15.
The issue is I don't need 15 before or 15 after, I need 15 consecutive regardless of where they fall in the calendar.
The days are PTO requested days off, so if someone is going to be out for 15 days or more, I need to notify someone as soon as possible even if the absence is 6 months from now.
