Aggregate( function

I’m having trouble with this and would appreciate help:
This formula: aggregate(“LiveMeetings”, “count”,“contains “Ethics””)
gets the error message “Expression contains an operand when an operator was expected.”
No combination of quotes I use makes any difference.
I’m sure I’m making a rookie mistake, but…

Your formula is:

contains "Ethics"

When you view it on it’s own like this, hopefully it’s obvious what the problem is – you need an operand on the left side of the contains operator. In this case, probably a field name. Probably something like this (I made up a field name).

Topic contains "Ethics"

I see now. I was thinking that having the field name as the first parameter took care of that. Thanks!

Jim gave the correct answer already.

But it does not hurt (and makes the syntax clearer) to use curly brackets to include the query formula:

aggregate("LiveMeetings","count",{Topic contains "Ethics"})
1 Like