4 Replies Latest reply on Jul 1, 2016 1:35 PM by Derrick Austin

    "No Data" values are not involved in the count while calculating average

    zibal jafri

      Hello Everyone,

       

      I have few "no data" values in my table. Hence, when I am trying to calculate the average of that measure column, I am getting it wrong as count of the records for that column records is not including the records which have "no data".

       

      For example in the above picture if I try to calculate Average of the First column, It should be (10+67)/5 since there are 5 rows, but it calculates the average as (10+67)/2 as it ignores the rest of the 3 rows where it doesn't have data.

       

      Please let me know how I can resolve this issue. Thanks in advance.

       

      Regards,

      Zibal