I have a portal for all jobs.
I then have a second portal to jobs that filter jobs with a positive P/L. Therefore only Job that are loosing money will appear.
This use to work until the client request this change.
They wanted to select the date range for the P/L. They only way to do this was to set to global fields: Start Date / End Date.
These global fields are used to calculate P/L for only transaction within the date range. It works great and is very fast. But now the filter on the portal no longer works. It shows all jobs both positive and negative.
So I assume that when using a global field in the calculation that is then used for the filter FileMake decides I am insane and should consider a new profession like sheep herding.
Not on the sheep herding, on the filter just to be clear.