Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like below..
sum( {<[To_YEAR] = {'$(=Max(R_YEAR)+2)'},POL_TYPE={'R'}>} [PREMIUM] )