1 Reply Latest reply: Nov 17, 2016 3:42 PM by Richard Judkins RSS

    Cumulative output not wanted

    Richard Judkins



      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!