Formulas used for Calculated Series
I'm trying to find documentation on what the formulas are that are used for the various selections for SSRS2008 Calcuted Series. In particular, the Performance formula appears to be based on the slope of the underlying data points. But, what is the true calculation used? I can not find this information anywhere (in MSDN and in searches).
October 19th, 2009 10:24pm

Hi Katy,I can't understand your problem correctly. Could you make it more clear? then here will be someone can help you.thanks,Jerry
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2009 6:32am

Hi Jerry. Let me use a specific example. In Microsoft Visual Studio 2008, I have a SSRS reporting project in which I have a chart that shows cost savings by month. Month is the category and cost savings is the series data . For such a chart, I can select the series (cost savings), right-click and select add a calculated series. In the drop-down list for Formulas, one of the list items is "Performance".When I add a caluclated series with a formula of "Performance", I get a line that appears to be roughly the slope of the underlying series (change in cost savings over time delta), but scaled so that the line does not go negative (which it would, potentially, for a regular slope).My question is, what are the mathematical formulas used for the various calculated series? I'm sure that these are documented somewhere, but where?Thanks,Katy
November 6th, 2009 8:58pm

Hi Katy, Perhaps I'm a year too late, but FWIW I stumbled across your post while hunting for the same info. I haven't found a very definitive reference, but the following info provides descriptions of each formula: http://technet.microsoft.com/en-au/library/microsoft.reportingservices.ondemandreportrendering.chartseriesformula.aspx If anyone from MS is listening, we'd appreciate some more detailed information on those formulas. Mike
Free Windows Admin Tool Kit Click here and download it now
September 22nd, 2010 9:54am

Mike, Thanks for the link. I agree with you're request for more detailed information also. KatyKaty Lynn McCullough-Leonard
October 6th, 2010 11:02pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics