3 Replies Latest reply on Sep 19, 2018 7:07 AM by Gerardo Varela

    Comparing today to yesterday

    Andy Hulsey

      Attached is a packaged workbook with sample data.

       

      What I am trying to do is compare the average rate on the Max([Report Date]) to the rate on the day before the Max([Report Date]). The average rate is a measure where for each day there is a single row. I have created a LOD to find the Max date as follows:

       

      {Fixed: Max([Report Date])}=[Report Date]

       

      And then I use that to get the Average Rate for that day. I am stuck on how to get it for the day before. I tried variations on the LOD above to get Max date -1, but no luck so far.

       

      Any thoughts?

       

      Thanks!

       

      Andy