Post reply

SSRS expression

  • January 29, 2014 at 7:26 am

    #287746

    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 5:40 pm

    #1684510

    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

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

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