Home Forums Reporting Services Reporting Services New to SSRS help ! write expression according to condition RE: New to SSRS help ! write expression according to condition

  • March 20, 2010 at 5:35 am

    #1137166

    Hi,

    Try this

    =SUM(IIF(Fields!tickets.value = "P" or Fields!tickets.value = "C" and Fields!ticket_date.Value = today()-1, 1, 0))