12 Replies Latest reply on Sep 28, 2014 5:56 PM by Matt Lutton

    Calculated field for last day of a given week (not the weekly average)

    luciana.suran

      Hi

       

      I have a dataset of stock prices and I am interested in looking at how the price moves week to week. However, I don't want to look at the average, I just want to look at the most recent stock price for Friday versus last Friday's stock price. Is there a way to do this with a calculated field? Thank you.