Sum Overlapping Time/Remove Timeframe Gaps
Hi all, is there a way to do this formula queries? I have a table of people who have child residence & employment records, with start & end dates for each, as well as a numeric field that summarizes ...
Forum Discussion
The most elegant solution is Tableau or PowerBI. This has alot of potential out comes and if your reporting requirements expand, it might be very hard to get new data.
For a pure Quickbase solution, I would create three fields on each person.
2 mile count
3 mile count
4 mile count
At the end of the month I would have a Pipeline go through your child tables and then update the count on the Person table. You will need to do a Search inside of a Search to check both child tables and then if either or both are true, only add one more month to the appropriate field for the totals.