Summary report show groupings with zero values

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
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? 
Photo of Alex Gale

Alex Gale

  • 1,428 Points 1k badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of Justin Torrence

Justin Torrence

  • 648 Points 500 badge 2x thumb
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.
Photo of Alex Gale

Alex Gale

  • 1,428 Points 1k badge 2x thumb
Oh wow, that's such a simple solution. Thank you.