3 Replies Latest reply on Oct 23, 2018 9:27 AM by swaroop.gantela

    Return Date associated with Max Value

    Nathan Haines

      So what i am trying to do is return the date associated with the highest bid value on something very similar to the attached - this is not necessarily the last bid it received as you will see from my example.

       

      Ultimately the end goal i would like to achieve is to write a stat that says 'if you had sold on your highest bid, this would have taken an average of x number of days, rather than the current average of x' - and so the registration or dates wouldn't actually be in the view

       

      Does anyone know how i can achieve this? I have tried a few different ways of LODs referencing other LODs but couldn't get to what i needed.

       

      Thanks in advance,

       

      Nathan