Skip to main content
Question

Total item count issue

  • July 2, 2018
  • 0 replies
  • 28 views
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.
    This topic has been closed for replies.

    Please give two of samples of sample data for the 12 fields and th3 result you want.
    • EudonDelemar
    • Author
    • Registered
    • July 2, 2018
    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
    Count(

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

    ...

    Field12] >0)

    That will count the number of fields with values > 0
    Terms & ConditionsAccessibility statement