- After i save i run in to this message
Answer
how do i fix encounting divide by zero errors
Best answer by BenjaminCrisman
Seems like it’s the Decimal conversion which is messing it up. You can either set this expression:
=IIF([ARTran.Cost]<>0, [ARTran.ExtPrice]/([ARTran.ExtPrice]-[ARTran.Cost]), 0)
Or you could try to set a filter like this:
With the filter active you could remove the IIF part and just use
[ARTran.ExtPrice]/([ARTran.ExtPrice]-[ARTran.Cost])
The best option would be to add an IF condition to the formula that looks for zero values in the denominator and adjusts them accordingly
+4
You could put like =IIF([ARTran.Cost]>0, CDec([ARTran.ExtPrice]/([ARTran.ExtPrice]-[ARTran.Cost])), ‘’)
+4Yeah, I made those single quotes in this text editor on the site, you’ll need to replace them with regular single quotes in the GI expression editor :/
I’ll try to remember that this happens and paste my expressions in rather than build them in this text box
+4Try this:
=IIF([ARTran.Cost]>0, CDec([ARTran.ExtPrice]/([ARTran.ExtPrice]-[ARTran.Cost])), '')
+4Seems like it’s the Decimal conversion which is messing it up. You can either set this expression:
=IIF([ARTran.Cost]<>0, [ARTran.ExtPrice]/([ARTran.ExtPrice]-[ARTran.Cost]), 0)
Or you could try to set a filter like this:
With the filter active you could remove the IIF part and just use
[ARTran.ExtPrice]/([ARTran.ExtPrice]-[ARTran.Cost])
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.