Previous year figures

[#1]

I have a problem with my expression to populate purchases amount for the previous year, sum({$<Year={$(=Only(Year)-1)}>}LineTotal)  . The one to get current year figures sum({$<Year={$(=Only(Year))}>}LineTotal) is working perfectly fine.Can someone assist me in fixing this.

[vijay_iitkgp]

I have checked your expression and it is working fine for me.

[jagan]

Hi,

Try with this expression

sum({$<Year={'=$(=(Max(Year)-1))'}>}LineTotal)

Regards,

jagan.

[#4]

Thanks, let me try it