Been struggling for a while to find a Boolean condition to filter out the following scenario:
If Customer Name has registration year = 2014 and 2015 then return rows
If customer Name has registration year = 2014 but couldn't find a matching record in 2015 then return rows
Test3 | 2014
The thing is customer name/ID needs to be taken into consideration as i need to verify if the policy was renewed by the Customer and identify which policies were not renewed. I'll be dealing with 100,000+ rows so hope that gives an idea
Thanks in advance!
If you are only working with years 2014 and 2015
then you could do a sum and do a check if Sum(Year) =4029 ------> 2014+2015
This should give you the condition an the view you require.
Hope this helps.