13 Replies Latest reply: Dec 7, 2017 4:37 PM by Marco Wedel RSS

    Calculate KPI

    Andrea Cristiano

      hi guys,

           I have a little problem with KPI calculation.

       

      I've this situation:

       

      Dateemployeesrevenue

      01/01/2017

      5

      120000
      01/02/20175125400
      01/03/20175150000
      01/04/20175140000
      01/05/20175132500

       

      I have to calculate revenue / employees like :

       

                          sum(revenue) / employees

      that is:

                          667900 / 5

       

      But on qlikview if I write:

                     = sum(revenue) / employees


      I get back " - " symbol


      so I try:

                = sum(revenue) / sum(employees)


      this works but the result is incorrect because the values are:

                          667900 / 25

       

      How can I do?


      This is an example and the original table have more values than this.


      Thanks