Create a Trend Line at Cognos Report Studio

One day, I got an assignment to make a trendline at Cognos Report Studio, and after searching from Google, i found out how to make it from IBM site <http://www-01.ibm.com/support/docview.wss?uid=swg21340501>


From that site, u'll find how to resolve this problem, ..here is it..

You have to using N values of X and Y, and fitting the line to the expected Y' values for given X values we do the following

Y' = a + b*X

a = (Average(Y)*Total(X*X) - Average(X)*Total(X*Y))/(Total(X*X)-N*Average(X)*Average(X))

b = Total(X*Y) - N*Average(X)*Average(Y)/(Total(X*X)-N*Average(X)*Average(X))

Then it'll be:

Y'= ((total(minimum([X]*[Y] for [X]) for report)-total(minimum(1 for [X]) for report)*average(minimum([X] for [X]) for report)*average(total([Y] for [X]) for report))*[X] + (average(total([Y] for [X]) for report)*total(minimum([X]*[X] for [X]) for report)-average(minimum([X] for [X]) for report)*total(minimum([X]*[Y] for [X]) for report)))/(total(minimum([X]*[X] for [X]) for report)-total(minimum(1 for [X]) for report)*average( minimum([X] for [X]) for report )*average( minimum([X] for [X]) for report ))

Go to try it.. :p