Set Analysis

[zagzebski]

}Premium)

[CELAMBARASAN]

Hi,

     Try with this

     Sum({<[Incurred Year]={$(=Max([Incurred Year]))},[Incurred Month Num]={"<=Max([Incurred Month Num])"}, [Incurred Year Month]=>} [NET CHANGE CNT - ADJST])

Celambarasan

[zagzebski]

Thanks for the response. Unfortunately it just brough back "0"'s.

[Gabriel]

Hi Zag,

Can you expand on your question

[masha-ecraft]

I've fixed expression evaluation in the set analysis suggested by Celambarasan, this should work:

Sum({<[Incurred Year]={$(=Max([Incurred Year]))},[Incurred Month Num]={"<=$(=Max([Incurred Month Num]))"}, [Incurred Year Month]=>} [NET CHANGE CNT - ADJST])