Max Date in Expression

[Anonymous]

I am trying to only sum the max date in my expression, here is what I tried so far.

=Sum (if(SNAPSHOT_CCYYMM = 'Max SNAPSHOT_CCYYMM' and CLAIM_STATE= 'Open',1,0))

[swuehl · Accepted solution]

Maybe

=Sum (if(SNAPSHOT_CCYYMM = Max(TOTAL SNAPSHOT_CCYYMM') and CLAIM_STATE= 'Open',1,0))

or

=Sum (if(SNAPSHOT_CCYYMM = $(=Max( SNAPSHOT_CCYYMM')) and CLAIM_STATE= 'Open',1,0))

[Anonymous]

Thanks Steve the following one seems to work...

=Sum (if(SNAPSHOT_CCYYMM = $(=Max( SNAPSHOT_CCYYMM')) and CLAIM_STATE= 'Open',1,0))