11 Replies Latest reply: Jun 16, 2014 4:24 AM by Johan Bengtsson RSS

    Add monthly value to dates

    Johan Bengtsson

      Hi everyone!

      I have a table with target values for HitRate for each store, month and year that I like to add to each date within the month.

      TempHitrate:

      YearMonthShopHitRate
      2014jan10066%
      2014feb10068%
      2014mar10065%
      2014apr10068%
      2014may10067%
      2014jun10068%
      2014jul10064%
      2014aug10067%
      2014sep10068%
      2014oct10069%
      2014nov10068%
      2014Dec10066%

      I'd like to create a table with new field, Date (generated in the same way as in QV calender-script), and add Shop and the value from the field HitRate in the table TempHitrate above so the result looks like this:

      Hitrate:

      DateShopHitRate
      2014-01-3010066%
      2014-01-3110066%
      2014-02-0110068%
      2014-02-0210068%

      So the field Date matches with the correct month and year in the first table, and adds the value for HitRate.

      Is there anyone who know how to solve this I'm very greatfull!

       

      Brg Johan