6 Replies Latest reply on Mar 8, 2018 7:56 AM by paolo.raia

    Averages ignoring NULLS

    paolo.raia

      Hi,

       

      I would like to average a set of dimension figures and exclude NULL values, however I cannot seem to get the calculation correct (if there's a null value, the average is returning null):-

       

      Example:

      Dim1.....Dim2.....Dim3.....Dim4.....Average

      3............3............2............NULL....Should calculate as 8 divided by 3 and not 4

      3............3............2............4...........Should calculate as 12 divided by 4

      etc

       

      Thanks in advance.