14 Replies Latest reply: Jun 6, 2017 1:58 AM by Silambarasan Manickam RSS

    Last Closing Balance SUM Required

    zahid Rahim

      Dear Experts,

       

      I have a table with date and segment wise balances.

       

      Now I want to get total of all balances for the segment's last balance at any month closing.

       

      For Example:

      Date              Segment          Balance

      01-JAN-2017    A                     10

      02-JAN-2017    A                      11

      10-JAN-2017    A                       12

      31-JAN-2017    A                        13

      15-JAN-2017    B                         20

      31-JAN-2017    B                         25

       

      Now I want to get JAN Balances

      A= 13 (As it is last closing balance)

      B = 25 (As it is last closing balance)

       

      For total Jan Balance It should be 13=25=38

       

      Regards,

       

      Zahid Rahim