Percentage showing in Text Box #Num!

[Suresh_Murugan]

I making one of the total progress report. That is working but percentage some of the columns showing #Num!. (Calculating only 0/0 = #Num! values ). I want to hide this is. So please advise how to I hide this. See attached picture.

 

[Ranman256]

In the query for the report, put an IIF condition to trap the division by zero.

Iif([denom]=0,0,[num]/[denom])

 

[Suresh_Murugan]

Thank you Ranman256 It's working correctly.

 

[npatel]

Thank You...