Hi John

I've read the article you mentioned and it helps to clarify the matter..... really the author talks about the order of the evaluation of the CASE statement and never mention that the CASE in the SELECT is evaluated before the WHERE condition is applied.

But, as told before, to me is sufficient that some of the denominators are zero to indicate that the data are not correct, so I will correct the data anyway.

Many thanks for your precious help.

Have a nice day!

🙂