Could someone please tell me what is incorrect with this expression. I get a ')' expected error. Thank you!
=IIF((Sum(Fields!OwnerOccupied.Value)+Sum(Fields!Vacant.Value)+Sum(Fields!NoRentalUnits.Value)=Sum(Fields!NoUnits.Value), Nothing, "No Match"), "DataSet1")
Get rid of the second ( after IIF and the one after No Match"
=IIF(Sum(Fields!OwnerOccupied.Value)+Sum(Fields!Vacant.Value)+Sum(Fields!NoRentalUnits.Value)=Sum(Fields!NoUnits.Value), Nothing, "No Match", "DataSet1")