1 2 Previous Next 15 Replies Latest reply on Oct 3, 2018 6:07 AM by Deepak Rai

    Trying to make calculated column with the value of another column 30 days prior

    Geoffrey Bell

      Tried a few things here and seem to be struggling. What I am trying to do is compare actual revenue for a day vs projected revenue from 30 days prior. Tried the calculated field below but as you can see that just pulls the forecast revenue for today -30. What I'd like to do is populate the projected revenue column with the "Forecast Revenue" from 30 days before that date.

       

      I messed around with a date -30 field but still couldn't really wrap my head around it.

       

      Thanks for the help!

       

        1 2 Previous Next