# Quick Base Discussions

View Only

## Total item count issue #### Mr Delemar07-02-2018 02:15 #### QuickBaseCoach Dev./Training07-02-2018 11:35 #### Mr Delemar07-02-2018 13:08 • #### 1.  Total item count issue

Posted 07-02-2018 02:15
I have 12 Numeric formula fields that add up the sum of multiple devices. I also have a Total Item Count field. I want to be able to show if any of the field items are greater then 1 then add 1 to the Total Item Count. So the field will only add to it if there is a number in one of the 12 fields. for example if only 6 of the 12 fields have an amount then the total item count will be 6.

• #### 2.  RE: Total item count issue

Posted 07-02-2018 11:35
Please give two of samples of sample data for the 12 fields and th3 result you want.

• #### 3.  RE: Total item count issue

Posted 07-02-2018 13:08
Each of the 12 fields are calculating correctly. Its figuring out how to get the Total Item Count to calculate. For example
field 1 = 15field 2 = 0field 3 = 10field 4 = 12field 5 = 0field 6 = 10field 7 = 10field 8 = 0field 9 = 12field 10 = 10field 11 = 12field 12 = 0
Total item count = 8

• #### 4.  RE: Total item count issue

Posted 07-02-2018 14:01
Count(

[Field1] >0,
Field2] >0,
Field3] >0,

...

Field12] >0)

That will count the number of fields with values > 0