1 Reply Latest reply on Jan 4, 2017 4:19 PM by diego.medrano

    Creating a row in order to forecast by week #




      I am trying to create a calculated field that would first calculate the % change from week 2 to week 1.


      Second, based off the % change I want to average the % change from week 2 to week 1 for the last 3 years in order to help create my forecast.


      How would I create a calculated field row for this?  The 3 year average would then be used to forecast the next week based off actuals from the previous week.