Skip to main content
Question

Is there a way to show null values in a Summary Report

I am trying to create a Summary Report that summarizes the number of items as a normal value, and I am grouping the columns by item creation date, combined by month.

The table generates as expected. The column headers for the table show January, February, March, April, etc. in correct date sequence, and shows the correct count for the number of items associated to each month.

I have one problem. If the item count for a month is zero, I want to show it as zero. For my table, the months of April and November have zero items, but the table does not show those two months as column headers, with a value of zero.

Is there a way to do this?
    This topic has been closed for replies.

    There are two ways you could accomplish this.

    1. Create a new formula numeric field which basically convert the existing value into a numeric value even for now by doing a NZ. Use that new formula numeric field in your summary report and that should display.

    2. The other way to try is to Modify the field properties of the summary field to treat blank values as zero. Make sure that you are not filtering out any records in your summary table based on the field value being zero.
    @Avi. I don�t think your solution will work. The problem is that the summary report only summarize his records that exist and is not summarize records they don�t exist.

    So one solution could be to introduce a set of dummy records contrived to sort stay to the very bottom of the list which would show up for a zero value in all months. So you might need to load in 12 dummy records.

    If you report is currently counting the number of items, you can make a formula feel that would calculate to 1 for all of the real records but would calculate to a zero for the dummy records.

    Then rather than counting the record you would do a summary total of that account field where each record would have the value of one except for the dummy record which would have a value is zero.

    Then your summary report totals would still be correct as the final row in the summary report would have zeros all the way across it but in doing so would force all the months from January to December to appear.
    Terms & ConditionsAccessibility statement