Checking which machinery is free - I have tab...

(Marlene Williamson) #1

Checking which machinery is free - I have table with jobs containing a date [Start] and a Vehicle [Ref from the Vehicle Table [Vehicle]]. I want to know which Vehicles haven’t been allocated to a job on a specific day. Am thinking that it should be something like AND(In[Vehicle], look in the job list, [Start]=Today()) but cannot quite get how to phrase the formula. Can anyone help please?

(Aleksi Alkio) #2

Something like VechileTable[Vehicle] - SELECT(TableName[Vehicle],[Start]=TODAY())

(Marlene Williamson) #3

If I understand it correctly, that will give me a list of vehicles that have been allocated. It’s the a way to get a list of the others? That is, those in the vehicles table that do not have jobs on a given day?

(Aleksi Alkio) #4

This will do exactly that because of “-”. Read the whole list - assigned vehicles.

(Marlene Williamson) #5

@Aleksi_Alkio oh ok. Thanks very much indeed