Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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]))
=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!
=if(not Match ([Booked for Shipping Date],'20*'),null(),count([Booked for Shipping Date]))
TRY
No same number.
The number should be 1052
but right now it is 22119
see the file
Booked for shipping always showing null
may be you need to count distinct
Yeah or should I go on "tracking ID" instead?
Maybe something to do with the date?
missingcount([Booked for Shipping Date])