Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Tablix compute pct chg from previous year quarter Expand / Collapse
Author
Message
Posted Wednesday, July 6, 2011 4:32 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 18, 2012 9:14 AM
Points: 20, Visits: 78
Am having a problem in Visual Studio 2008 R2 tablix computing percent change from same quarter last year to this. The expression is in the Qtr detail row, and should be comparing count of FocusArea 2010-Q1 to count of FocusArea 2011-Q1.

Qtr is set up as a Child Column Group to its parent Year.

My expression is
=(COUNT(Fields!FocusArea.Value) - Previous(Count(Fields!FocusArea.Value), "Year"))/Previous(Count(Fields!FocusArea.Value))

I am getting a percentage but, based on the numbers displayed, it is not correct. I know the percentages showing in year 2010 will not be valid (since there is no 2009), but where did I go wrong with my expression???

Any help greatly appreciated!! ~Carol
Post #1137718
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse