Qrew LegendDo you have a relationship between drivers and callouts?
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.
