Date in Set Expression

upaliwije — Sun, 16 Feb 2014 14:56:41 GMT

In My attachment I have following dimension fields

R_Year,R_Month,To_Year, To_Month

when I select R_Year+2013 and R_Month=Jan

I want the following Results

To_Year=R_Year+2 and To_Month=R_Month and Pol_Type='R'

I have written the following expression but it is not working

sum( {<[To_YEAR] = {$(=max([R_YEAR]+2))},POL_TYPE={'R'}>} [PREMIUM] )

Pls look into my attachment and correct it expression to suit my requirement

Thanks

Re: Date in Set Expression

MK_QSL — Sun, 16 Feb 2014 15:37:13 GMT

Try like below..

sum( {<[To_YEAR] = {'$(=Max(R_YEAR)+2)'},POL_TYPE={'R'}>} [PREMIUM] )