Asked by:
Formulas used for Calculated Series

I'm trying to find documentation on what the formulas are that are used for the various selections for SSRS 2008 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).
Question
All replies


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), rightclick and select add a calculated series. In the dropdown 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 
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:
If anyone from MS is listening, we'd appreciate some more detailed information on those formulas.
Mike
