Hello All!
I have created a database to store the results of our internal audits. They get audited on certain elements. My problem is... For example the element is File Folder Contents worth 5 points, if applicable, if they do not have a file folder I would put 0 earned out of 0 available. In the queries I am asking it to find the average of their elements but it is then taking earned divided by available which is 0/0 which equals #ERROR.
Is there any way around this mathematical blunder?