Discussions

Expand all | Collapse all

Summary report show groupings with zero values

  • 1.  Summary report show groupings with zero values

    Posted 04-03-2019 14:50
    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.  RE: Summary report show groupings with zero values

    Posted 04-03-2019 15:03
    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.


  • 3.  RE: Summary report show groupings with zero values

    Posted 04-03-2019 15:11
    Oh wow, that's such a simple solution. Thank you.