5 Replies Latest reply: Nov 8, 2017 1:32 PM by Dave Melillo RSS

    Max Period - 1 Not Working

    Dave Melillo

      I have periods in my data set formatted as 11/1/2017

       

      The max period calculation is working

       

      PERIOD = {"$(=Max(PERIOD))"}

       

      But the previous period calculation is not

       

      PERIOD = {"$(=Max(PERIOD)-1)"}

       

      Any pointers here?

       

      Thank you,

       

      - dave