Exclude values from filter

[mg862925]

I want to exclude value in i a filter.

This is correct 

Count({$<[Status]={'Quoted'}>} [Status])

But after that I need to exclude some more from an other "Booked for Shipping Date"

I tried this =if(WildMatch ([Booked for Shipping Date],'20*'),null(),[Booked for Shipping Date])

But that didnt work.

See my csv file

[Channa]

if(match ([Booked for Shipping Date],'20*'),null(),[Booked for Shipping Date])

or

if([Booked for Shipping Date] like '20*',null(),[Booked for Shipping Date])

try

[mg862925]

it didnt work

I want this number to be reduced (I want to exclude all the "booked for shipping")

So to explain I want the filter to say "exclude all the "booked for shipping" or include all the "booked for shipping"

I want to display both options for different people at my work

[Channa]

you want to add condition to this

Count({$<[Status]={'Quoted'}>} [Status])

IF( isMissing(BookedForShipping ),Count({$<[Status]={'Quoted'}>} [Status])

=if(Match ([Booked for Shipping Date],'20*'),null(),count([Booked for Shipping Date]))

[mg862925]

=if(Match ([Booked for Shipping Date],'20*'),null(),count([Booked for Shipping Date]))

This Includes the "booking for shipping"

I get the correct number but I want it the other way

Only count the one that DONT have a booking for shipping

BTW

Thanks for all the help!

[Channa]

=if(not Match ([Booked for Shipping Date],'20*'),null(),count([Booked for Shipping Date]))

TRY

[mg862925]

No same number.

The number should be 1052

but right now it is 22119

see the file

[Channa]

Booked for shipping always showing null

may be you need to count distinct 

[mg862925]

Yeah or should I go on "tracking ID" instead?

Maybe something to do with the date?

[Channa · Accepted solution]

missingcount([Booked for Shipping Date])