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

Sum of results of an expression in SSRS Expand / Collapse
Author
Message
Posted Tuesday, October 01, 2013 5:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 04, 2013 12:51 AM
Points: 2, Visits: 6
Hi,

I have the below expression in result i am getting values for each month. Now, I want to calculate the sum of those results for all the months (Which i am already getting using the expression).

Also, I want the difference between the present and the past month from the result using the same expression.

Please help me...

The expression is ....

=IIF(Sum(IIF(Fields!Naming.value="Total Tickets",Fields!Totals.value,0))>0,Sum(IIF(Fields!Naming.value="Laptop Tickets",Fields!Totals.value,0))/Sum(IIF(Fields!Naming.value="Total Tickets",Fields!Totals.value,0)),Nothing)


Regards
Kishore
Post #1500353
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse