8 Replies Latest reply on Jul 18, 2016 8:31 AM by mikebeargie

    Get Count() of Field across found set

    DavidTinoco

      I have 3 fields in my companies table:

       

      type  = text field (set to either supplier or customer )

      isCustomer = number calc, If( type = "customer" ; 1 )

      isSupplier = number calc, If( type = "supplier" ; 1 )

       

      What I am trying to do is get a count of the isCustomer / isSupplier fields across a foundset.

       

      I realize Count(isCustomer) will not work, as it only evaluates based on the current record.

       

      ( sorting and Get(Summary) is not an option as it will mess up the user's records ordering ).

       

      Any ideas?