Forum Discussion

AlexGale's avatar
AlexGale
Qrew Captain
6 years ago

Summary report show groupings with zero values

I have a summary report which groups my records by month, and totals the number of records in that month that were overdue ("Was Overdue" being a simple checkbox). The problem is that the report does not show months where 0 records were overdue. Is there a way to set it up so that it shows those months, just with a 0 value under the total? 

2 Replies

  • Remove the filter for Was Overdue and change the Summarize Data field to key on Was Overdue It will count 1 for records that are checked and 0 for records that are not.
    • AlexGale's avatar
      AlexGale
      Qrew Captain
      Oh wow, that's such a simple solution. Thank you.