3 Replies Latest reply on Jul 13, 2016 7:40 AM by Tom W

    How to get the last available number

    Federico Echeverri

      I'm working on a graph with three fields; the two price forecast (orange lines) and actual prices (red line)graph.png

      The idea behind the graph is to show the price (red line) two weeks ago. The prices are published once a day for all weekdays, except saturday and sunday.

      I tried creating a field to show the last available price, but I clearly didn't do it properly because when there aren't any weekends, for example a wednesday, I get to see more than just the last possible price. Like this:

      graph2.png

      Attached you'll find the workbook.

       

      I would really appreciate any help regarding the correct string for the calculation.