Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
}Premium)
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
Thanks for the response. Unfortunately it just brough back "0"'s.
Hi Zag,
Can you expand on your question
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])