difference between Excel Average vs Incorta Average

there is a huge difference between incorta vs Excel average calculations in
excel if the column has null data it is considered as null, but whereas in incorta it nulls are overwritten with "0" which is causing a problem while calculating the average. 

please check the excel with the data, 

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Anurag Malik Amit Kothari could anyone answer this why incorta average is not matching with Excel

  • Hello Venkat,

    In Excel, empty cells are not taken into account. If you insert Zeros into those sells you will get the same values in in Incorta.

    Ahmed Esmat
    Customer Support Manager

      • venkatRao
      • Broadcom
      • Rao
      • 2 yrs ago
      • Reported - view

      Ahmed Esmat yes, agreed but empty cells should remain empty in incorta also right I mean as a null,  incorta replacing empty cells with zero which is causing the problem to calculate the average. when we have huge data sets where for example for surveys few users will respond and few may not. if we are calculating avg then avg is calculated on both repsonded and not responded too .. which totally gives the wrong metrics..  empty cells should read the data as nulls

Like Follow
  • 2 yrs agoLast active
  • 3Replies
  • 106Views
  • 3 Following

Product Announcement

A new community experience is coming! If you would like to have beta access to provide feedback, please contact us at community@incorta.com.