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