0 Replies Latest reply: Feb 15, 2018 5:44 PM by conor cliffe RSS

    Null handling for RangeSum(Before(Total

    conor cliffe

      Hello,

       

      I am trying to create a cumulative sum and I am using the below formula.  I have NULL values for some months and would like to see the last value available (ie the current cumulative sum and not 0).  The goal is that after I have at least 1 quantity, all of the subsequent months will have a value and not be NULL.  Attached is my result set.  Thank you.

       

      RangeSum(Before(TOTAL Sum([Quantity]), 0, ColumnNo()))