Counting Matching Lines in a List

Peter van Rooij pfvanrooij at
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


> On 19 Nov 2018, at 14:35, Andrew McVeigh <omnis at> 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
> _____________________________________________________________
> Manage your list subscriptions at
> Start a new message -> mailto:omnisdev-en at 

More information about the omnisdev-en mailing list