Summary report show groupings with zero values

Question

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?

JustinTorrence · Answer

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.

Sign up

Login to the community