David, I am using 2008

This one gives me an error:

=Sum(IIf(Fields!Wait_Status.Value="Within Target",Fields!Surgical_Case_Count.Value,0))

I think I've tried it before.

I think it needs to be done through lookup, so it looks where wait_status="within target" and takes a value from "surgical_case_count" (which is another column) and sums it up.

I just...

I am building the report using SQL report builder and "where" is not an option I thought. It doesn't work when I use: =Sum(Fields!Surgical_Case_Count.Value) where (Fields!Wait_Status.Value="Within Target")