Counting Matching Lines in a List

Peter van Rooij pfvanrooij at gmail.com
Mon Nov 19 08:38:52 EST 2018


Hello Andrew

Doug Kuyvenhoven once came with the $sendall() for this purpose:

Do List.$sendall(Total.$assign(Total+List.Col1*List.Col2),[Criteria])

for the product of two cols. You can adapt this.

Or You could use the totc() function

Best regards

Peter



> On 19 Nov 2018, at 14:35, Andrew McVeigh <omnis at surfway.com.au> wrote:
> 
> Simple question, what is the best way to count all of the matches in a list.
> I have a field that has either 0, 1 or 2 in it in the list and I want to count how many lines have 1 in that field
> 
> Andrew McVeigh
> Surfway Real Solutions
> Phone 02 44412679 Mobile 0418428016
> www.surfway.com.au
> www.berrarabeach.com.au
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 




More information about the omnisdev-en mailing list