I’m having trouble with a Division by zero error.

I’m trying to take to do the following:

the quantity canceled to date: “OL_QTY_CAN_TD” divide it by the quantity ordered “OL_QTY_ORD”

The formula below is what I thought would be to get around the Division by zero error.

Please let mw know what I’m doing wrong.

Canceled: Iif(Nz([OL_QTY_CAN_TD],0) <> 0, ([OL_QTY_CAN_TD]/[OL_QTY_ORD]), 0)


Thanks

Corey

Hi Corey,

I am thinking what you want to do is do the initial test on the denominator (OL_QTY_ORD), if that guy is 0 that would cause the division by zero error, whereas the other would just equal zero.

Hope that helps,

Mike

Mike
EchoVue.com

try this one: IIf([OL_QTY_ORD]=0,0,([OL_QTY_CAN_TD]/[OL_QTY_ORD]))

Dharmesh Bhavsar

That would work, but you would need to put add the Nz Function, incase OL_QTY_ORD is null.

IIf(Nz([OL_QTY_ORD])=0,0,([OL_QTY_CAN_TD]/[OL_QTY_ORD]))


Mike
EchoVue.com

It worked!!!

Thanks Dharmesh and Mike