Can someone please tell me what is wrong with this formula?
select (200 * (31- datepart (d,( getdate()))/31)
+ 200 + 200 +
datepart (d,( getdate()))/31*200
) /31 as MonthlyForecast
I get a return of 212. I was told the value should not be more than 200
using Lever law to get an average over 4 months.