4 Replies Latest reply on Jul 25, 2018 2:23 AM by Rico de Feijter

    add total of parent id to total of child id

    Rico de Feijter

      Hello,

       

      I have the following parent_acct_id, called ACE in 'Sheet 1':

       

       

      I want to add the total of this one (i.e. -550.267,37) to the total of rekening 0500, which is a child of the parent_acct_id PRV and has the total -2.233.052:

       

      I tried to make a calculation in sheet 2:

       

      I want the calculation to return the result of  -550.267,37 +-2.233.052. However, it returns:

       

       

      How can I make the calculation return  -2783319,37, which is the result of -550.267,37 +-2.233.052?

       

      My workbook is attached.