I’ve created a slice “NotInProgress” which on testing returns the correct data I asked it to do, in this case there are two rows to return:
AND([PreBookedDateNoTime] <= TODAY(), [JobStatus] = “AUTHORISED”, [JobType]<>“Mechanical”)
When I create a view using the Slice it doesn’t work and returns far too many rows and not the data from the slice.
I’m stumped as to why?
.
Solved! Go to Solution.
AND([PreBookedDateNoTime] <= TODAY(), [JobStatus] = “AUTHORISED”, [JobType]<>“Mechanical”,ISNOTBLANK([PreBookedDateNoTime]))
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |