3 Replies Latest reply: Jun 26, 2014 7:49 PM by Gil Lion RSS

    Joining Tables to new table + calculation

      Hi.

       

      I have table_1 (excel) with fields:

       

      YearMonth

      Sum

       

      I have table_2 (excel) with fields:

       

      YearMonth

      Total

       

      I want to create table_3 out of those two with fields:

       

      YearMonth

      Sum

      Total

      Calc = Sum / Total

       

      and drop the tables and keep with table 3.

       

      How do i do it?

       

      Thank You.