PIN OwnerNum Effectivity Year Total Tax pin123 1003 2014 2,000.00 pin456 4002 2015 1,500.00
I really find this hard because i'm conducting BI report for Real Property Tax System that has no future or past entities for effectivity year.To simplify the data, I created a module whose effectivity year is <=2015. I want to fetch the highest effectivity year only per pin and owner.Thanks for all your help.
Here's my script
Date(Max(yr)) as pyear,
PCINum&'-'&MDINum&'-'&BINum&'-'&SINum&'-'&Parcel&'-'&PType as Pin3;