none
Formulas used for Calculated Series

    Question

  • 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).
    Monday, October 19, 2009 7:24 PM

All replies

  • 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
    Wednesday, October 21, 2009 3:32 AM
    Moderator
  • 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
    Friday, November 06, 2009 5:58 PM
  • 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

    Wednesday, September 22, 2010 6:54 AM
  • Mike,

    Thanks for the link.  I agree with you're request for more detailed information also.

     

    Katy


    Katy Lynn McCullough-Leonard
    Wednesday, October 06, 2010 8:02 PM