3 Replies Latest reply: Jul 18, 2013 10:36 AM by Gysbert Wassenaar RSS

    Issues using the "Avg" function

      Hi All,

       

      Has anybody experienced any issues using the avg function within Qlikview?

       

      I have created a straight table containing 14 lines of data (by date) for a number of fields 'units' 'visits' & 'conversions' (units/visits)

       

      I have some text boxes that will display summarised values, the text boxes containing sum("fieldname") are fine but those with avg("fieldname") are not producing the correct values.

       

      Sure I am missing something straightforward or simple somewhere but I cannot seem to fathom it out - can anybody help??

       

      Thanks

       

      (Unfortunately due to business constraints I cannot post the app - but a screenshot demonstrating the prob is below)