December 22, 2010 at 7:42 am
I'm very new to SSRS 2008 and have the following problem:
I have a simple expression in my SSRS Matrix report data region which essentially calculates a percentage:
=SUM(Fields!DTs.Value)/(SUM(Fields!DNs.Value))
This works fine but when i add a date field in my Matrix table rather than calculating the above percentage for each individual month i get the same % for all months ie rather than 54% in March, 65% in April, 78% in May, 67% in June, etc i just get 76%, 76%, 76%, 76%. What do i need to do!!!
The date field works in the Matrix table when there isn't an expression involved but seems to come unstuck with the percentage calculation. Do i need to use the Inscope function to resolve this?
Any help on this would be really, really appreciated
January 12, 2011 at 1:05 pm
Is the 76% the average of all the months' data? If that's the case, try dropping the SUM() from the expression and just say:
=Fields!DTs.Value/Fields!DNs.Value
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply