I am wondering how I should go about handling weighted by month calculations for a trending report. Currently, I just use (total/<month>
* 12 to get the trending number.
I work at a law firm where all the attorneys have a target number for the year. Based on historical numbers by month, each month is weighted (the tendency is that they close more towards the end of the year so it is weighted heavier).
As a stop gap (due to time limitations), I am going to use static numbers until I can create something to calculate the weight 'on the fly'.
So my questions is, should I do the calculations in the expresion on report or with T-SQL in SELECT statement?
How should I handle cumulative weighted total?
These are the static percent numbers by month:
(0.04, 0.06, 0.09, 0.08, 0.09, 0.08, 0.09, 0.09, 0.08, 0.09, 0.08, 0.13)