2 Replies Latest reply: Nov 29, 2010 4:26 AM by Markus Meijer RSS

    Total amount in a Pivote table

      Hi,

      I have a problem with my Pivot table.

      The system doesn´t calculate the total amount. Each line is correct but it doesn´t give me the total.

      error loading image

       

       

      The problem is in the last column "nyttjandegrad"

       

      =((sum(qty_produced))/((sum(opworked_time)*24)-sum(opworked_time_stopptid)*24))/(resource_efficiency*60)

       

      Thanks in advance

      Markus