3 Replies Latest reply on Aug 30, 2017 10:07 AM by Jim Dehner

    Average on Measure Values when null values

    mafalda.santos

      Hi all,

       

      I have 3 KPIs and want to calculate the average for measure values.

       

      First Approach (AvgTest1):

       

      KPI1+KPI2+KPI3/3

       

      (didn´t work because I have null values)

       

      Second Approach (AvgTest2):

      zn(KPI1)+zn(KPI2)+zn(KPI3)/3

       

      (didn´t work because (/3). For East instead of 2+3/3=1.67 the correct result is 2+3/2=2.5

       

      Any help on this ?

       

      thanks in advance

       

      Mafalda