Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The Wildmatch() will return either 0 or 1, that's what you count.
Use something like
=Count( DISTINCT If(Wildmatch(..), [Management ID]))
The Wildmatch() will return either 0 or 1, that's what you count.
Use something like
=Count( DISTINCT If(Wildmatch(..), [Management ID]))
Got it, thank you Stefan.
Have a nice weekend.