5 Replies Latest reply on Jan 11, 2017 2:54 PM by David Kuder

    Trend Line Calculation

    Briann Tisdale

      Is there a method to capture Trend Line Analysis in to a Custom Calculated Field? My goal is to calculate the value of the trend at a specific point in time.

       

      The attached workbook with sample data shows a milestone trend over time; Bar = Actual, Line  = Projected. It would be ideal to change the color of the Projected line if it is above or below the trend line at 12/31/2012.

       

      Any assistance would be greatly appreciated, Thanks

       

      -Briann