Error

Business Central/NAV User Forum
1

How expert, I have a textbox control in the RDLC report, which has expression as (sum A/sum B)*100.
But when B is equal to zero, X will be showing ERROR since it is divided by zero exception.
I have tried the following in the textbox control expression, but it still shows error for those when B is zero. Please advise! Thank you!

=IIf(Sum(Fields!B.Value)=0,0,Sum(Fields!A.Value)/Sum(Fields!B.Value)*100)

2

Try this:

= IF( ISERROR( SUM('ResellerSales_USD'[SalesAmount_USD]) /SUM('InternetSales_USD'[SalesAmount_USD]) )
    , BLANK()    , SUM('ResellerSales_USD'[SalesAmount_USD])   /SUM('InternetSales_USD'[SalesAmount_USD])  )



[http://technet.microsoft.com/en-us/library/ee634214.aspx](http://technet.microsoft.com/en-us/library/ee634214.aspx)
3

IIf statement is tricky because preparing the argument list the compiler calls every function in every expression, so it’s not possible to rely on “else” part not being executed. To avoid this it’s possible to use a nested IIf, such as:

=IIf(Sum(Fields!B.Value)=0,0,Sum(Fields!A.Value)/IIf(Sum(Fields!B.Value)=0,1,Sum(Fields!B.Value))*100)