Counting number of rows in a table with a condition

So, you can count the number of rows in a table, eg
Let T be the number of filled rows in Table of Dogs

but can you count the number of rows in a table that meet a condition, eg the number of filled rows in a table where the dogtype entry is “hound”, as easily? Or do I need to resort to iterating through the list and counting each row that meets the condition?

You could (see 16.5):

choose a row with a dogtype of “hound” in the Table of Dogs;

which would choose the first row that contains the “hound” entry and you could then start your iteration there. If your table is so big you’re still concerned about performance, you could try sorting it by dogtype (16.11).

edited to add: I checked the Index>Phrases tab and it doesn’t look like there’s a phrase that does precisely what you asked for. Also, only use quotes if the dogtype entry is a topic or some text meant to be said. If it’s a kind of value, lose the quotes.

HTH

Noted. Thanks for the reply, Mike