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



      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.