I have one requirement in which i have to satisfy 3 scenarios below.
Below is how my data looks like, Please Note that the Same worker can work many times according to their contracts which can last from 1 week up to a year also.
I have to satisfy all the 3 scenarios below.
1) Who have not been working with us for the last year that is between 2016-2017?
- if YEAR([Contract Start Time]) = 2016 then 'out' else 'in' END
(Have Taken Only the workers that are IN As we don't want the workers who have worked between 2016 to 2017)
2) But have been working before last year.
NOT SURE HOW TO DO THIS
3) Who have been paid in the year 2017?
- Can directly take STATUS field in filter and make it PAID
-Also put Year(Contract Start Time) = 2017 in Filters