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

    Get Count() of Field across found set


      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?