Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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))
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))
Thanks Steve the following one seems to work...
=Sum (if(SNAPSHOT_CCYYMM = $(=Max( SNAPSHOT_CCYYMM')) and CLAIM_STATE= 'Open',1,0))