Hi -
This dataset basically represents leases in buildings and I am trying to identify all leases with no modifications (which is indicated by the generation).
I am trying to figure out an expression for a filter to return records that for each BLDG and OCCID, there is only a single Generation. I have attached the input and I have color-coded the ones in green that I would like returned.
Please help! Thanks.
