8 Replies Latest reply: Mar 7, 2017 2:03 PM by Sunny Talwar RSS

    Calculation Issue

    Mark Ritter

      I have a field that is calculated in the script and it is returning the correct result.  It is called TotalPay


      However, when I Sum(TotalPay) I get a much larger result.  Also, if I calculate TotalPay manually in the chart I get the same larger result.

      This would make me believe that I have multiple rows that I am not seeing in the chart because the data is identical.  But the Sum is adding them all up.


      How can I go about confirming this or determining what is wrong?


      I have attached a screen shot of the data.  As you can see there is only 1 row displayed.