6 Replies Latest reply on Jun 6, 2019 12:36 PM by Ron Chipman

    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