Thanks!

But I would like to ignore the NULL columns in my divisor

e.g. TOTALAVR = (ISNULL(AVR1,0) + ISNULL(AVR2,0) + ISNULL (AVR3, 0) / (Count Only NON-NULL Columns)

Some of my columns have NULL values in the Avg This Hotel Year and Avg All Hotels.

How do I handle this case?

Also I want to ignore the NULL values...