Cumulative output not wanted

[Anonymous]

Hi.

I have the following:

if(Sum(if(year(TRANS_DATE)=2016, QTY,0))>0,  rangesum( above( sum(if(year(TRANS_DATE) = 2016,QTY,0)),0,rowno())),null).

Call it MTD 2016.

It's for a bar chart, which I want to show the monthly QTY actuals for 2016, 2015 and 2014.

However, it is showing a cumulative result month on month, not monthly QTY actuals.

I have zero doubt it is extremely simple to fix. However, I am clearly simpler, and can't do it. Any help greatly appreciated thanks!

[Anonymous · Accepted solution]

Actually, never mind. Worked it out - just straight Sum(if(year(TRANS_DATE)=2016, QTY,0))

Thanks for reading my question though!