I attach a file with sample data for a case of comparison between years.
I specified data and the request.
Thanks for any help!
I have these data:
I want to count new entries in 2014 with CODE "FR".
The result in this case is 2 i.e. YY and ZZ, because they are not in 2013 and they have code "FR".
KK is excluded beacuse its code is "WEB"
XX is excluded because is already in 2013.
Where's the year to start with? What should you be comparing actually, meaning, which field? How is that check on another field, which field must be compared to which? In the script or UI?