ChrisM@Work (5/8/2014)
Otherwise you will get answers like this:
SELECT *, Trend = ([Week]/5.0) * MAX(Forecast) OVER(PARTITION BY [TYPE])
FROM #REport
Which exactly meets your requirements (apart from the trivial matter of rounding) but is almost certainly incorrect.
Chris ...your mind reading skills are quite extraordinary 🙂
but have a suspicion that OP has oversimplified........we can wait and see
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day