2 Replies Latest reply: May 22, 2013 3:06 PM by Dmitriy Vanyukov RSS

    Calculate most recent price point

      Greetings experts!

       

      I am attempting to get most recent price per Location, SKU. The issue is that I do not have a fully populated price field I can easily use and I was hoping that there is some Set Analysis hacketry that could get us there.

       

      For each Date, Sku, Location price would be defined by a record of same, or preceding date, of the same SKU code and location.

       

      In following example we're determining a price for the SKU 'ZYX4321', Location 2 on the date of 20130102

       

      Date-Sku-Loc.png

      Since the records are ordered by the date, we would navigate up the list to find latest record with a price and matching SKU, Location

       

      Date-Sku-Loc_Match.png

       

      QVW with my attempted solution is attached. Any help or insights you might have are greatly appreciated!

       

      D