7 Replies Latest reply: Jul 11, 2016 10:10 PM by Sunny Talwar RSS

    Avg function not producing the correct value

    Chris Douty

      Qlik Sense Question:

       

      The avg function is not producing the correct value.

       

      I have an app that contains two sheets. The first sheet is made up of visualizations and filters, and the second page is a table which contains every dimension (no measures or calculations).

       

      I select my desired filters, and then confirm the total amount of rows on the second sheet's table (it correctly matches the total counts from the first page). One column in this table is annual_salary. If I use the average function (annual_salary), I receive a number that does not match excel's average function on the same column.

       

      Note:

       

      1. The table is set to display all null values.

      2. The column does not contain any 0's, or nulls.

       

      Has anyone encountered similar issues with the avg function?