7 Replies Latest reply: Oct 17, 2017 3:19 AM by Stephen Hasson RSS

    Summation error

    Stephen Hasson

      Hello,

       

      I have a calculated field in a grid that works fine, taking a value X and multiplying it by the value Y to give Z.

       

      X is pulled from a part's record representing an amount of explosive per KG, Y is the qty (in KG) of a part in stock. Z = the total explosive amount for the part.

       

      On a grid showing all the parts, quantities, the warehouse codes etc. the calculation works fine:

      =round(NEQPerItemKG*sum(OnhandQty), .00001)

       

      But if I have a similiar grid, but take out the part/qty etc, in order to see totals by warehouse, the calculation doesn't work.

       

      Screen shots attached. Any help appreciated.

       

       

      Thanks.