Exclude values in kpi

[mg862925]

I am having problem to exclude values in KPI

I want to exclude all the C in "inspected grade"

And the same question for "transaction type" and "Status"

I want to exclude "try"  in transactions type

I want to exclude "Qouted" in "status"

See CSV file for example

[Channa]

try use if(Not match(inspected grade,'*C*,inspected grade)

[mg862925]

Hi

if(Not Match ([Inspected Grade],'C*'),[Inspected Grade]) does not work 😞

[Channa]

u need to use some aggregate function it will not work with that expression i will come back 

[Channa · Accepted solution]

=Count({$<InspectedGrade-={'C'}>} InspectedGrade)

=Count({$-<InspectedGrade={'C'}>} InspectedGrade)

try both

[mg862925]

Thanks! It worked! 🙂