5 Replies Latest reply: Aug 9, 2018 9:46 AM by Laura Holland RSS

    Cumulative sum for months when no transaction in month

    Vivekanand Joshi

      Hi,

       

      I am trying to show cumulative sum over the months, but there are no transactions in some month. i still want to show total upto previous month though. in next month, if there is a transaction, the sum should be updated.

       

      For example, right now my chart looks like this :

       

      cum.PNG

       

      But I want to show 116 for the month of April and May as well. Then 167 for Month of June which is correct. Is this possible?

       

      The formula I am using for cumulative sum is :

       

      Aggr(RangeSum(Above(Sum(Qty_Ord), 0, RowNo())),Year,Month)

       

       

      Thanks,

      Vivek