withanlemmon@advantastar.com

Do a count of all empty fields

Discussion created by withanlemmon@advantastar.com on May 9, 2017
Latest reply on May 15, 2017 by philmodjunk

I wish to do a count of all empty (or inversely full) fields in a table for a given record. Is there a quick way to do this without having to type of each one?

 

I have a table of checklists, with hundreds of fields and I want to know what percentage of the fields are empty for any given record. Do I have to write a calculation with each and every field in it?

Outcomes