#Num! on Report RRS feed

  • Question

  • I have an report that contains a calculation in many of the controls.  For example, 0ne calculation divides one number by another.  Unfortunately, when both numbers = 0, my report displays "#Num!"

    Is there anyway I can replace "#Num!" with "0"?

    Please keep in mind that the control already contains a calculation, so I can't put any code in the control.  I'm wondering if I can put some code in one of the report events that would make the substitution upon launch?


    Tuesday, June 9, 2020 9:20 PM


  • I figured it out.  Here's the original calculation:


    Here's the fix:


    • Marked as answer by Kenrav Tuesday, June 9, 2020 11:50 PM
    Tuesday, June 9, 2020 11:50 PM