Hi Everyone
got a small problem, i have a query/report that has quite a few fields, as its a summary page it has alot of calculated fields as well. One of these fields is Absolute % Varience (the formula for which is based on two fields, oldQTY and newQTY, formula is: ((newQTY-oldQTY)/oldQTY) * 100)
sometimes oldQTY and newQTY are both equal to zero, in this event i get #Num! as an answer, is there any way i can use something (similar to =nz() ) to make this field a zero instead (tried =nz, however that did not work)
got a small problem, i have a query/report that has quite a few fields, as its a summary page it has alot of calculated fields as well. One of these fields is Absolute % Varience (the formula for which is based on two fields, oldQTY and newQTY, formula is: ((newQTY-oldQTY)/oldQTY) * 100)
sometimes oldQTY and newQTY are both equal to zero, in this event i get #Num! as an answer, is there any way i can use something (similar to =nz() ) to make this field a zero instead (tried =nz, however that did not work)
zero divided by zero = #Num!
0 commentaires:
Enregistrer un commentaire