how can i return a null when summing and deviding columns values when some of the values have nulls
how can i return a null when summing and dividing column values when some of the values have nulls or zeroes. Basically want to return a null when I sum up multiple column values whenever some of the values have a zero or null. Here is my current query that I am trying to use to accomplish this but its not returning null as expected.
(((CAST (column1 AS NUMBER) - 57.81114) / 24.79211) + ((CAST(column2 AS NUMBER) - 40.7836082505127) / 17.5946375921401) + ((CAST (column3 AS NUMBER) - 49.4958123953099) / 27.9601909416896) ) / 3 Grand_Total,