Forum Discussion

PenelopeWilson's avatar
PenelopeWilson
Qrew Member
2 years ago

Formula to Count # of records for consecutive business days

We have drivers who must call a system that records their callouts.  QB creates a record for each EID callout.  I need to create a report that returns the EIDs - that call out 11 business days in a row. .  HELP!



------------------------------
Penelope Wilson
------------------------------

9 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    2 years ago

    Do you have a relationship between drivers and callouts?



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • PenelopeWilson's avatar
      PenelopeWilson
      Qrew Member
      2 years ago

      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.



      ------------------------------
      Penelope Wilson
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        2 years ago

        It 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.



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------