I am having an challenge with this SSRS expression. I need add REPORT_NAME "AIA1610U" in the expression to narrow my results down in the report.
Not Sure what I am doing wrong here. How would I go about doing that? Any Assistance would be great.
=SUM(IIf(Fields!NAME.Value = "TOTAL OUTSTANDING APPLICATIONS" ,Fields!DAYS_AGO.Value ,0),"rsOutstandingApplications")- SUM(IIf(Fields!NAME.Value = "ELECTION FORM RECEIVED" ,Fields!DAYS_AGO.Value ,0), "rsOutstandingApplications" )
I figured my issue out. Here are the results of the correct answer.
= SUM(IIf(Fields!NAME.Value = "TOTAL OUTSTANDING APPLICATIONS" AND Fields!REPORT_NAME.Value = "AIA1610U", Fields!DAYS_AGO.Value ,0),"rsOutstandingApplications") -
SUM(IIf(Fields!NAME.Value = "ELECTION FORM RECEIVED", Fields!DAYS_AGO.Value ,0), "rsOutstandingApplications" )