Calculating Percentage Change

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Ryan » Calculating Percentage Change

Calculating Percentage Change

Rate Topic

Display Mode

Topic Options

Author

Message

Ryan

Posted Thursday, September 27, 2007 3:03 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, December 07, 2012 12:07 PM
Points: 100, Visits: 68

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

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

Post #403781

lirioescano

Posted Monday, July 04, 2011 9:28 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, July 05, 2011 7:13 PM
Points: 1, Visits: 3

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

Post #1136060

« Prev Topic | Next Topic »

Permissions