Home Forums SQL Server 2008 SQL Server 2008 - General Sum function where field = RE: Sum function where field =
David Burrows
SSC Guru
Points: 65138
More actions
May 8, 2014 at 7:13 am
#1711840
Try
=Sum(IIf(Fields!Wait_Status.Value="Within Target",Fields!Surgical_Case_Count.Value,0))
Far away is close at hand in the images of elsewhere.Anon.