AnsweredAssumed Answered

Get Count() of Field across found set

Question asked by DavidTinoco on Jul 18, 2016
Latest reply on Jul 18, 2016 by mikebeargie

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?