6 Replies Latest reply: Oct 17, 2011 11:54 PM by Anand Chouhan RSS

    Writing formula. Subtracting Count between 2 tables.

      Hi,

       

      I have 2 tables and they have the same values as follows:

       

      Table1:

      Field, Count1

      A,1

      B,2

      C,3

      D,4

       

      Table2:

       

      Field, Count2

      A,5

      B,3

      C,8

      D,9

       

      i want to generate a 3rd table like:

       

      Field, Count1-Count2

      A, -4

      B,-1.....

       

      The value of Field is same. Table 3 should take the counts and subtract it based the values A, B, C,D...

       

      thanks and i will appreciate your responses.