1 Reply Latest reply: Jul 2, 2015 7:02 AM by Gysbert Wassenaar RSS

    insert targets (excel) by date

      Hello guys,

      I want to insert a target table for salesperson by date and link that with the master calendar

      How can I realize that ?

       

      I Have all of my data in one table:

       

      ALL:

      DocNo,

      Date,

      Salesperson,

      Amount,

      ...

       

      ExcelTarget:

      Salesperson & '|' & Date as %KEY_TARGET

      Salesperson,

      Date (2012 - 2015, fictitious dates per Month and year once ..)

      TargetMonthAmount, TargetMonthAmount*12 as TargetYearAmount  ( OR TargetYearAmount, TargetYearAmount/12 as TargetMonthAmount)..no relevant which way.

       

      My problem is, I can't join / combine the 2 Date table, even with Join ..