7 Replies Latest reply: Feb 14, 2017 3:24 PM by Stefan Wühl RSS

    Incorrect SUM value

    Andrew Moberg

      I have a value which is supposed to SUM room minutes, however I cannot get the value to line up with the manual calculation.

      Here is my table model:

      Tbls.png

       

      Here are the individual values for the room minutes:

      Mins.png

      The sum of this is 1880

       

      Here is what I get when using the SUM function:

      The value represented from this formula is 1970...?

      sum.png

       

      Why is the SUM value incorrect?