2 Replies Latest reply: Aug 10, 2012 1:40 AM by Sabrina Richter RSS

    Formula with fields of two tables in script

    Sabrina Richter

      Hi all,

       

      I believe I have a very simple problem.

      I have got two tables and want to calculate sth. with one field of each of them. They are connected by the ID.

      Table1:

      ------------

      ID

      Name

      Days

       

      Table2:

      ------------

      ID

      DaysOff

       

      Now I want to subtract Days-DaysOff as a new field in Table1.

      So I started like this:

      left join (Table1) LOAD ID, Days-DaysOff as TotalDays resident Table2;

      I also switched Table1 and Table2 but I dont get it. TotalDays should be a field of Table1. In the best case I do not want to JOIN them. I know this would be a solution.

       

      Thanks in advance!