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?

Outcomes