5

I have a Matrix Report that is based on a Custom Report Type. The Custom Report Type has 3 levels: "A" records may or may not have "B" records and "B" records may or may not have "C" records.

Report

The Report uses one B field on the left ("Name") and one B field on top ("Scheduled release Date"). B records without Cs now have a Record Count of 1 although there is definitely no record. What is shown in the table is an empty column.

Chart As a consequence of this the chart also shows wrong numbers. Any ideas? I want to have the empty B records also in the table and in the chart, but with the correct record count of Cs of zero.

1 Answer 1

6

Take a look at The Power of One, this really helped me build a number of reports. If I'm understanding your data model correctly, you'll want to add a new formula field to the C object, call it "Number_of_C__c" or something similar, the Formula should just be a Number with the value "1".

Then, if you update your reports to summarize by the "Number_of_C__c" field instead of RecordCount, Salesforce will automagically calculate the number of C records in that particular grouping, including zero. This will also fix the related Chart as well, provided that you update the Y-Axis to use the new field.

Example Setup

3
  • I use this on pretty much every object in my org.
    – Mike Chale
    Nov 27, 2012 at 18:06
  • Very cool solution, never heard of it! Nov 28, 2012 at 8:02
  • Thanks a lot - this is a perfect solution for the problem!
    – user969
    Nov 28, 2012 at 9:44

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .