Help with Formula/Summary Report
I have a table of customers that contains two dates, essentially a starting and ending date, and the state they are located in. I am trying to develop a summary report showing me a count of customer...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI think that the only way to do this would be to have a pipeline create a child record for each month that the customer is active. The do your reporting off the child table. You can have one pipeline which fires whenever a Customer record is added or the date modified which would delete all its children (if any) and then rebuild them. .... And then a nightly safety net Pipeline to delete all the children and rebuild them.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thank you! The only way I could come up with it was spinning up a new table, but was hoping there was some wizard forumla I was missing. Thanks!
------------------------------
bcloud
------------------------------