Total item count issue

• 0
• Question
• Updated 11 months ago
• (Edited)
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.
• 112 Points Posted 11 months ago

• 0

QuickBaseCoach App Dev./Training, Champion

• 69,572 Points Please give two of samples of sample data for the 12 fields and th3 result you want.
• 112 Points 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

QuickBaseCoach App Dev./Training, Champion

• 69,572 Points Count(

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

...

Field12] >0)

That will count the number of fields with values > 0