Quick Base Discussions

Expand all | Collapse all

Total item count issue

  • 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