I have these 2 expressions that i need help with. I am getting syntax errors. 1.)if isnull(unitamount) or isnull(billqty) then 0 else (unitamount)*(billqty) I tried to convert this expression ssrs and i get a syntax error where i unlder lined.. =iif (isnothing(Fields!UNITBIDAMOUNT.Value) or (isnothing(Fields!BILLINGQTY.Value) ,0,Fields!UNITBIDAMOUNT.Value)* Fields!BILLINGQTY.Value  2.) sum({@itemAmt},{wonumber}) + {@UnitTotal} @itemAmt is an expression : if(unitbill) = 0 then 0 else (totalnetprice) SSRS conversion: iif(fields!unitbill.value=0),0,fields!totalnetprice.value) + @unittotal which is this expression if isnull(unitamount) or isnull(billqty) then 0 else (unitamount)*(billqty) Please help me thank you FM

The direct translation would be... =IIf (IsNothing(Fields!UNITBIDAMOUNT.Value) OR IsNothing(Fields!BILLINGQTY.Value), 0 , Fields!UNITBIDAMOUNT.Value * Fields!BILLINGQTY.Value) Jason Long

Hi Farhan1, Have you solved the issue following jasl90's reply? If not please give a feedback. I think it should be your answer. Thanks.Please remember to mark the replies as answers if they help and unmark them if they provide no help.