evend
asked on
Crystal Error Trap
If have the formula below and get division by zero errors? Help please.
if (({Vend_Visit_Items.ending _inv_calc} /WeightedA verage ({Vend_Visit_Items.estimat ed_ads}, {Vend_Visit_Items.estimate d_ads}, {Vend_Visit_Items.descript ion}))) = 0 then
0
else
(({Vend_Visit_Items.ending _inv_calc} /WeightedA verage ({Vend_Visit_Items.estimat ed_ads}, {Vend_Visit_Items.estimate d_ads}, {Vend_Visit_Items.descript ion})))/7
if (({Vend_Visit_Items.ending
0
else
(({Vend_Visit_Items.ending
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Remember dividing by 0.01 is the same as multiplying by 100
Dividing by 0.00001 is the same as multiplying by 10000
mlmcc
Dividing by 0.00001 is the same as multiplying by 10000
mlmcc
ASKER