Expression

[upaliwije]

sum( {$<To_YEAR=,[To_MONTH]{'<$(=Max([R_MONTH]))'}>} [PREMIUM] )

I have  written the above expression and it is not working. Pls check my attached document see what is wrong.

What I want to calculate is sum of Premium for the selected period and importantly To_month<R_Months

[albertovarela]

You were missing an equal sign after the To_MONTH

sum( {$

  <

   To_YEAR      =

  ,To_MONTH   = {'<$(=Max([R_MONTH]))'}

  >

  } [PREMIUM] )

[upaliwije]

Thanks for your reply

But still it is not working. Can U pls check with my document reply to me  with attachment

Thanks

[er_mohit · Accepted solution]

Try this

sum(if(num(To_MONTH)<num(R_MONTH),PREMIUM))

or

sum( {<[To_MONTH]={'<$(=Max([R_MONTH]))'},To_YEAR>} [PREMIUM] )

[Peter_Cammaert]

If you want to sum() all values for To_MONTHs lower than R_MONTH, then why put To_MONTH as a dimension in your chart? Remove the dimension, correct the expression as suggested before and it will work.

Peter