Report - using the Summary option by Count, when the cells are blank it groups by blank but does not
Reports - using the Summary option by Count, when the cells are blank it groups by blank but does not count the blanks and displays '0'. I have about 200 rows that have a null value in the column I am summarizing, but the count is displayed as 0 (zero) instead of 200. How can I get the report to count the blanks?
Answers
-
Here is a screen shot for an example. The column I have it summarizing is the 2nd to last column in the peach color to the right.
-
After further testing I understand that the cells need to have data in order for the summary count function to display the number of rows. Curious though if there is a workaround to where I don't have to populate the blank cells and still have the summary count the number of empty cells?
-
What about applying the Summary COUNT to the Sheet Name column? The Sheet Name cell will always be populated if there is a row associated with your current grouping, so you should see an accurate count of rows.
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives