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

SSRS expression Expand / Collapse
Author
Message
Posted Wednesday, January 29, 2014 7:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, September 22, 2014 4:19 AM
Points: 50, Visits: 303
Hi,

This expression calculated the difference between two columns and divides the value by 60.

=(Sum(Fields!DBA_Estimate.Value, "dsStatistics")-(Sum(Fields!DBA_Actual.Value, "dsStatistics")))/60

But if I get an minus value then I need to display 'Actual time is more than the estimated time'. How to do this?

Please help.

Thanks
Post #1535907
Posted Wednesday, January 29, 2014 5:40 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 4:17 PM
Points: 183, Visits: 8,145
I'm not sure if the syntax is quite right, but something along these lines might work:


=IIF( (Sum(Fields!DBA_Estimate.Value, "dsStatistics")-(Sum(Fields!DBA_Actual.Value, "dsStatistics")))/60 < 0, "Actual time is more than the estimated time", (Sum(Fields!DBA_Estimate.Value, "dsStatistics")-(Sum(Fields!DBA_Actual.Value, "dsStatistics")))/60 )


Doug
Post #1536143
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse