Create a report where "null" (or blank) is counted

Help Center Get Answers
1

Hello --

I have a simple table to record authors of books. For each author (~1000) I will record the sex (male, female, other, etc). I want to produce a report to show progress on filling in all those values. So I want to show the % of male, female, other, and not set. I can't see a way to bucket the blank/null/not set values in to a group that can be counted. Is that possible?

Thanks in advance..

2

Hello Bill,

 

This is possible by using a new table (parent table) only one row .. connected to each row of your table .

 

in that table you add 4 new field one for mail , one for female and one for other options.. 

 

and each field is count field (Count()) with where conditions 

 

Regards,

Sunny Singla

ssingla1985@gmail.com

+919855089359