Hi Guys.
I have a slice which returns a [TransportType] which the data returned would contain the following values.
COLLECTION
DELIVERY
MAKE AVAILABLE
In the slice, how do I exclude MAKE AVAILABLE ?
In my world of Access Queries it would be something like NotIn(โMAKE AVAILABLEโ) so what would be the syntax in the slice and where would I put this in the editor?
Kind Regards
Hmmmโฆ I donโt understand your use of the terms โsliceโ and โreturnโ. I would have to guess that you want to create a slice that includes only rows with a TransportType column value that is not MAKE AVAILABLE
. To do so, use the following as the sliceโs row filter expression:
("MAKE AVAILABLE" <> [TransportType])
Can this be extended Steve.
("MAKE AVAILABLE" ,"COLLECTION",<> [TransportType])
Multiple parameters as above?
It certainly could! Try and figure it out and let us know what you find.
OR([JobStatus] = โAUTHORISEDโ, [JobStatus] = โCOMPLETEโ,[JobStatus] = โESTIMATEDโ,[JobStatus] = โAUTH-REQUESTโ,[JobStatus] = โAPPOINTMENTโ,[JobStatus] = โNOTIFICATIONโ,[JobStatus] = โIN-PROGRESSโ)
Thanks Steve, this seems to give me the filtered data I need ( Based on a different dataset but its correct)
Kind Regards
how aboutโฆ
in([JobStatus], list(โAUTHORISEDโ, โCOMPLETEโ, โESTIMATEDโ, โAUTH-REQUESTโ, โAPPOINTMENTโ, โNOTIFICATIONโ, โIN-PROGRESSโ))
Whenever I get a list of options this big, I typically start thinking backwards - what statuses do I NOT want - that might be a shorter list.
Good shoutโฆ Thnks for your version.
Kind Regards
Not(in(โMake Availableโ, [TransportType]))
Cheers Guys
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |