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

    Summation error

    Stephen Hasson



      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.