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

    Cumulative output not wanted

    Richard Judkins

      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!