0 Replies Latest reply on Jul 25, 2012 5:50 PM by hub.yoo

    Find the last update for a date value

    hub.yoo

      Hello,

       

      I hope there is a quick and easy solution for this. I'm trying to make a calculation based on landed_cost. Problem is that it gets updated quarterly and therefore there can be many landed_Cost values associated with a partnumber. I was wondering if there is a way to find the last entry in the last_update (date dimension)

       

      I tried using lookup and last() but then i get the error saying that these functions must be used with an aggregation.untitled.JPG