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

    Sum a select statement

    Rani Bosch

      Hi,

       

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

           1. GL entries

                     Fields:

                               Document number

                               Amount

           2. Value entries

                     Fields:

                               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?