Home Forums SQL Server 2008 T-SQL (SS2K8) Need Help Writing a SQL Query that can provide a 6 Month Forecast RE: Need Help Writing a SQL Query that can provide a 6 Month Forecast

  • I stuck the values in Excel and used the FORECAST function.

    The X value was period 14

    Known X's were periods 8 thru 13

    Know Y's were the pcts for periods 8 thru 13.