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 ).