8 Replies Latest reply on May 8, 2018 8:38 AM by Cerys Heath

    Null values in running total appear at start date - how to move to end?

    Cerys Heath

      I am trying to make a retention chart - a running percentage of how many customers have renewed, throughout the year. I have a data set which looks something like this:

       

      Customer IDDate renewed
      124/03/2016
      2[Null]
      301/05/2016
      etc

       

      I've been able to get a cumulative running percentage by adding a Table Calculation to do Running Total (Number of Records) and then edit that to add a secondary calculation: Percent of Total

      However, all the null values seem to go in at the start of the year, so it looks like we begin on e.g. 30% renewed and then this gradually rises to 100% at the end of the year. I want the null values to count as not renewed, i.e. the year should end at 70%.

       

      Is there a way to do this? I've attached sample data and a sample workbook.

       

      Renewals sample.JPG