7 Replies Latest reply: Feb 19, 2013 4:12 PM by Robert Ebner RSS

    Compare month to year with two different tables

    Robert Ebner

      Hi, I have the problem, that I would like to calculate something per month compared to an value per year. In Table 1 there are the months and in Table 2 there are the year.

       

      Table 1:

      A_Jan;                10

      A_Feb;               13

      A_Mär;               13

      A_Apr;                15

       

       

      B_Jan;                 10

      B_Feb;                15

      B_Mär;                14

      ..

       

      Table 2:

      A;                          3

      B;                          2

      C;                          4

      ..

       

      I want to calculate in this way:


      A_Jan / A;  

      A_Feb / A

      A_Mär / A

      ...;  

      B_Jan / B;  

      B_Mär / B

      ...

       

      How could I handle this? Any Idea? Thank you for help!