3 Replies Latest reply on Nov 16, 2016 6:20 AM by malou.puyod.0

    Incorrect average and count distinct output

    malou.puyod.0

      Hi,

       

      I hope someone could help me on my scenario where there are times that getting the COUNT DISTINCT and AVERAGE values result to incorrect output. 

       

      For count distinct, I have tried using ZN([Column]) and some others that I searched from net but still it doesn't work.  For average, I also tried using the workaround SUM(Column) / COUNT(ID) and others but it also won't work.  We use database as data source so if those average or count distinct failed to display the correct values we result to doing workaround in the source table which is we want to avoid because it means additional column/s or repeating rows.

       

       

       

      I have attached the workbook and sample data for your reference.

       

      Regards,

      Malou