Fitler records - single generation leases

[cireost]

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.

[jamielaird · Accepted solution]

Hi @cireost 

This should do the trick: