5 Replies Latest reply on Jul 8, 2016 4:50 AM by Luciano Vasconcelos

    Previous Rolling 3 months from parameter- HELP

    Mikey Michaels

      Hello All,

      I have a quick question. On the attached, I'm trying to compute the utilization percentage for orders that went through our "EASy" order processing system.

      With the help of this forum, I was able to create a "Current Rolling 3 months Utilization", which looks at the utilization percentage of the last 3 months based off my parameter.

       

      Now, I need help creating a calculated field that would look at the "Previous Rolling 3 months Utilization". This would look at the next 3 months based off my parameter. To clarify, if my parameter was set at 1/31/2016, the "Current Rolling 3 months Utilization" would calculate for months November 2015, December 2015, and January 2016.

      While the "Previous Rolling 3 months Utilization" would calculate the usage percentage based off August 2015, September 2015, and October 2015.

       

      Any ideas on how to solve?

       

      See attached.

       

      Cheers,

      Mikey