Post reply

SSRS Expression

  • January 29, 2014 at 7:31 am

    #303841

    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

  • January 29, 2014 at 7:37 am

    #1684321

    Just use an IIF statement...

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

  • January 29, 2014 at 8:21 am

    #1684336

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply