3 Replies Latest reply on Jun 4, 2019 11:27 PM by sabarish yanduru

    Help with Sum

    Nick Isas

      hi I need some help please I have 2 files

      the table in the first one is similar to

       

         

      methodsunitsdesignyear
      DPP5190013772019
      DPP319001377

      2019

       

      the table in the second one is

        

      designPlannedYear
      19001377502019
      19001377152019

       

       

      I joined on the design field. When I try to display the sum of units and planned I get the following. How would I get the expected results of 8 and 65?

       

      thanks appreciate the help.