16 Replies Latest reply: Oct 17, 2017 9:25 AM by Shashank Vyas RSS

    Sum a select statement

    Rani Bosch



      I have the following situation where I've got 2 tables:

           1. GL entries


                               Document number


           2. Value entries


                               Document number

                               Cost amount


      My issue is that the cost amount in the value entries can consist out of multiple lines. Thus I need to sum the cost amount for each document number.


      I can then work out the GP% for each invoice posted.

      how can i group the cost of each document number in the value entries table, and only the value entries table?