2 Replies Latest reply on Jan 10, 2017 7:44 AM by Matthew Risley

    3 month average for ZN data

    giles.somers.1

      Hi

       

      I'm trying to show the 3 month average of data for all customers

      Some will not order each month, so there are null values and I've used ZN to overcome this.

       

      I can then calculate a rolling 3 month average based on this data.

      However, displaying the values for only the last month in the data set, creates issues.

      The null values that were converted to zero and used in averages, disappear when I filter the month.

       

      Several other routes also have similar problems.

       

      Does anyone please know a way of showing the last month of a moving average using ZN values?

       

      Many thanks