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

    Creating a row in order to forecast by week #

    stephen.ta.0

      Hi,

       

      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.

       

      thanks