September 27, 2007 at 3:03 pm
Comments posted to this topic are about the item Calculating Percentage Change
Ryan
-----------------
www.quadrus.com
July 4, 2011 at 9:28 am
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