Count & Wildmatch ( '*-??')

[Anonymous]

Hello everyone,

I'd like to count Management-IDs (companies) for certain business areas.

I only want to count those ManIDs that end with '-??'.

In this example, only the 33 ManIDs at the bottom should be counted (the ones that end with -01/-02 etc.)

I've tried the displayed expression but I don't fully understand the wildmatch function yet, the returned value is 2.

Thanks for your help.

Best regards,

Mats

[swuehl · Accepted solution]

The Wildmatch() will return either 0 or 1, that's what you count.

Use something like

=Count( DISTINCT If(Wildmatch(..), [Management ID]))

[Anonymous]

Got it, thank you Stefan.

Have a nice weekend.