I am trying to evaluate a Price per Kilo ($/Kg) based on sales of a product. This works fine if the product was acutally sold during the period specified. However if the product is not sold the Kg (the denominator) ends up being 0 (zero) and an error results. – Divide by Zero error.
I tried this
It appears that the
iif function is calculating both the true and false results. How do I get around this.
Should I be using the
switch function instead?