Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
sum(if(num(To_MONTH)<num(R_MONTH),PREMIUM))
or
sum( {<[To_MONTH]={'<$(=Max([R_MONTH]))'},To_YEAR>} [PREMIUM] )
You were missing an equal sign after the To_MONTH
sum( {$
<
To_YEAR =
,To_MONTH = {'<$(=Max([R_MONTH]))'}
>
} [PREMIUM] )
Thanks for your reply
But still it is not working. Can U pls check with my document reply to me with attachment
Thanks
Try this
sum(if(num(To_MONTH)<num(R_MONTH),PREMIUM))
or
sum( {<[To_MONTH]={'<$(=Max([R_MONTH]))'},To_YEAR>} [PREMIUM] )
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