The desired result would be the oldest unfinished task for a particular set of workers. However what the exclusion statement should achieve, is that it ignores certain tasks for certain customers.
Now attached you will notice that when starting from 1 table, the expression works perfect. However as in my real app, where I stumbled upon this problem, when there are several tables involved - QV will behave differently.
Any ideas on why this is? And more importantly, is there a way to fix this?
I would expect the same output as for the app where everything is contained in 1 table.
For example CAB has 2 open tasks 'cook'. One of these is for a customer that is in the exclusion on 17/01/2018, the other is created on 28/02/2018. In my first app the last formula correctly calculates that the oldest open task is 28/02/2018. In the second app I made a second 'Workers' table where I assigned the name Alberto to 'CAB'. Here the formula gives me the overall minimum date.