Post reply

Calculating Percentage Change

  • September 27, 2007 at 3:03 pm

    #178164

    Comments posted to this topic are about the item Calculating Percentage Change

    Ryan
    -----------------
    www.quadrus.com

  • July 4, 2011 at 9:28 am

    #1347927

    Hi. I am working on a report, using SRSS, where I need to compute for the percentage change for the current fortnight versus the previous fortnight. The date range of the current fortnight is a parameter setting. Thus the previous fortnight is dependent on this current date range. To illustrate:

    Current fortnight: June 20, 2011 to July 3, 2011 (parametized)

    Item Count

    -------------

    A 5

    B 3

    C 11

    D 2

    E 0

    Previous fortnight: June 6, 2011 to June 19, 2011

    Item Count

    -------------

    A 4

    B 1

    C 13

    D 2

    E 6

    Thus the resulting values I need to see are as follows:

    Item % Change

    -------------

    A 25%

    B 200%

    C -15.00%

    D 0%

    E -100%

    Can you suggest a script that I can set up/use in SRSS to get the percentage change, one that is similar to the sample function at the start of this discussion? Thanks!

    Lirio

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply