Hya gents,

I am working in GridView and for some weird reason the filter

MATCHCOUNT({Trx Acct}, "16231, 16232, 16233, 16234, 16235, 16236, 16237, 16238, 16239, 16241, 16290, 16203, 16215, 16216, 16410" ) > 0 is always returning true and it should not.

Is there a problem with the function or perhaps it is something I have missed?

Thank you and,

Cheers, JK

I believe that the correct syntax would be:

MATCHCOUNT(Trim({Trx Acct}), "16231", "16232", "16233", "16234", "16235...)

If any one of these 5 digit numbers exist as a {Trx Acct} in any record then the result is true (> 0). I'm not sure if the order of processing is the entire table or individual records.

Which table are you using with the field Trx Acct?

I've never seen that function used before. What are you trying to accomplish?

Thank you for your reply,

We are trying to view a subset of accounts....

Cheers, JK

If the accounts have something common in the description (say "BUSTER"), then a formula like this:

would work better. Alternatively, you could load one of the optional fields in Ledger and test it for a specific value.

We'll be training explicitly on how to do this at the Adagio Opportunity Conference pre-conference GridView training. Why isn't someone from Island Tug registered for the event?

Although the Help implies that this should work the fact is that MATCHALL, MATCHANY and MATCHCOUNT are "fuzzy" match functions.

MATCHALL does say

"This is an fuzzy match function, where a result may be returned if the match is close but not exact."

Try