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. 

       

      Capture.PNG