December2000
asked on
Divide by Zero Error in SSRS
Hi Experts,
How do I rewrite this expression to allow for divide by zero errors?
How do I rewrite this expression to allow for divide by zero errors?
=iif( Fields!SERVICE_QTY.Value > 0 and Fields!BILLSEPARATE.Value= -1, round(Fields!TOTALNETPRICE.Value,2)/round(Fields!SERVICE_QTY.Value,2),Fields!TOTALNETPRICE.Value)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER