2 Replies Latest reply: Apr 16, 2013 9:53 PM by Johannes Sunden RSS

    Sum is not getting same value fields

      I have 2 tables, TABLE1 and TABLE2.
      TABLE1 has columns ACCNO, descr and VALUE

      TABLE 2 has columns ACCNO, descr, SEQ and VALUE.

       

      In the image you can see both tables that I reloaded with different names to not tie up the data.

       

       

      Problem is, when I tie those tables with ACCNO and descr columns, the sum only gets the different values, which you can see in the image.

      The RECVD value on the upper left table is 150 and should be 300 ?

       

      Any ideas ?

       

      Attached are test.qvw and excel files.

       

       

      Untitled.jpg