6 Replies Latest reply on Dec 12, 2017 11:40 AM by Chase Mueller

    Have MAX date and want the prior date in the report as well

    Chase Mueller

      I am trying to create a view that includes the most current Plan Date, as well as the previous Plan Date (Next to Last Value).  Have tried Previous Value and MAX -1, among a number of other things that I read on the forum.  Nothing allows me to include the previous Plan Date and run a calculation on the difference.  Hoping someone out there can help me.  I have included the packaged workbook with the main view on the first tab, and something I tried on the 2nd tab to achieve the Next to Last Value, but I cannot manage to bring them together the way I want.  Thanks.