Expression with variable

[suvechha_b]

Hi All ,

Please assist me in getting the measure correct - 

I have max year in my script - SET vMaxUWYear=Max([UWY_KEY]);

But the below expression is not having result -

Measure - sum({$<[UWY_KEY]={$(vMaxUWYear)}>}GROSS_CLAIMS_PAID)

Please assist.

Thanks in Advance.

[sunny_talwar · Accepted solution]

Try this may be

Sum({$<[UWY_KEY] = {"$(=vMaxUWYear)"}>} GROSS_CLAIMS_PAID)

Or this

Sum({$<[UWY_KEY] = {"$(=$(vMaxUWYear))"}>} GROSS_CLAIMS_PAID)