Wilematch text filtering and count

[Evan0211]

I have a request to do some text filtering (which I know is a bad idea but unfortunately it's the only option at this time) and I am trying to get the totals in an overview table.

The overview table looks like this

No. of Entries

Title

Low

Medium

High

The No. of Entries is simply:

=if(
Match([OFFICE_CODE], $(vFilterOffice)),
count(R_TITLE)
)

That is working fine. The Low, Medium, High counts however always return -

I have tried the following different methods and can not get the count to return.

=if(wildmatch(R_TITLE, '*Low*'), count(R_TITLE))

=if(
Match([OFFICE_CODE], $(vFilterOffice)),
(
if(wildmatch(R_TITLE, '*Low*'), count(R_TITLE)
)
)
)

Any ideas?

[Or · Accepted solution]

Try moving the match statement inside the count() statement, rather than vice versa, e.g.

Count(wildmatch(R_TITLE,'*Low*'))

or Count(if(WildMatch(R_TITLE,'*Low*'),1))

Or using set analysis rather than if() statements.

[Evan0211]

Thank you, moving it inside the count statement worked.