Forum Discussion

RajHelaiya's avatar
RajHelaiya
Qrew Captain
7 years ago

Count number of populated fields among a group of 10 numeric fields.

I have a group of 10 numeric fields, some of them contain data and some don't. I want to count the number of fields which contain data, for example if field 1 contains <3241>, field 2 contains <4567>,...
App builders
Ask about Quickbase functionality
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
You can use the count function to count "trues".  There is a question as to how to deal with blanks.  if the fields are NOT set to treat blank as zero (ie to treat them as null)

Count(
not IsNull([Field 1]),
not IsNull([Field 2]),
...
not IsNull([Field 10]))

If they are set to treat blank as zero then

Count(
[Field 1]<>0,
[Field 2]<>0,
...
[Field 10]<>0)