I Create a report with some formula such like this :
({OPI_HEAD.QTY_PESAN}/{OPIM_Det1.ISI})/500

from the report display there's no error message. But when the report were exported into excel or another there's an error " division by zero "

please any one tell me to solve it out..

thanks,


Yokanan

I would make one minor change.  If there's a possiblity that {OPIM_Det1.ISI} will be null, you'll need to use this formula:

Unfortunately, that's not the case.  I'm not entirely sure that it's a division by 0 error, but it does cause an error instead of just returning null.

I'm pretty sure I've gotten this error from nulls....but I don't remember the exact circumstances or version of Crystal.