function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Nate BakerNate Baker 

Custom Summary Formula: count non null rows

I'm trying to create a report summary formula where, instead of dividing by RowCount, I want to divide by only non-null rows.
My current formula is:
(Survey_Results__c.CS1_ABC_Category__c:SUM/RowCount)

I need to only count rows that are non-null.

Thanks.
Andy BoettcherAndy Boettcher
How do you determine if a row is "non-null"?
SteveMo__cSteveMo__c
+1 AndyB 
Is there a field that you're evaluating to determine non-null?  
Can you post a screenshot of the Report and the Filters, Groupings, Settings that you're currently using and a create a mock-up of what you want your Report to look like?  ​For questions related to Analytics: Reports and Dashboards those are really helpful.   
SteveMo__cSteveMo__c
You might want to think about using Tom Tobin's "Power of One" and amend your formula to divide by the count of a specific record 

https://success.salesforce.com/0D53000001GwrJW