Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 columns, Vendor and Tax Code. Ideally, a vendor would only use one code. However, exceptions may occur. I need to display the total number of exceptions. So if I have 10 vendors and 3 of them use more than one tax code, I need to display 3 as my answer. The difficulty is that the data is structured like this:
Vendor Code Amount
ABC X1 100
ABC X2 150
DEF X1 120
DEF X2 130
GHI X1 115
ABC X3 130
In this example, Vendor ABC uses 3 tax codes, and Vendor DEF uses 2 codes. So the result should be 2 exceptions.
Any ideas?
Hi!
Try something like
Count(Distinct {<Vendor = {"=Count(Distinct Code) > 1"}>} Vendor)
Let me know any doubts about the expression.
Regards,
Jaime.
Hi!
Try something like
Count(Distinct {<Vendor = {"=Count(Distinct Code) > 1"}>} Vendor)
Let me know any doubts about the expression.
Regards,
Jaime.
Try this
Count(DISTINCT {<Vendor = {"=Count(DISTINCT Code) > 1"}>} Vendor)
Perfect. Thank you both so much for your help! 🙂