Total item count issue

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
  • (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.
Photo of Mr Delemar

Mr Delemar

  • 80 Points 75 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
Please give two of samples of sample data for the 12 fields and th3 result you want.
Photo of Mr Delemar

Mr Delemar

  • 80 Points 75 badge 2x thumb
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
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
Count(

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

...

Field12] >0)

That will count the number of fields with values > 0