Total item count issue

Question

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.

quickbasecoachd · Answer

Please give two of samples of sample data for the 12 fields and th3 result you want.

eudondelemar · Answer

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

quickbasecoachd · Answer

Count(  [Field1] &gt;0,  Field2] &gt;0,  Field3] &gt;0,  ...  Field12] &gt;0)  That will count the number of fields with values &gt; 0

Forum Discussion

Total item count issue

Related Content

Running Total

Totaling Child Records Live on Parent Form

Missing Records/Data Issue

Quickbase App Issues

MIME Pipeline issue