Pain in the *** Nulls

[Anonymous]

Is there an easier way, a global way possibly, to deal with Nulls so that I don't have to keep turning expression like this:

Column(3)-Column(1)+Column(2)

into expressions like this:

if(isnull(Column(3)),0,Column(3))-if(isnull(Column(1)),0,Column(1))+if(isnull(Column(2)),0,Column(2))

[Oleg_Troyansky · Accepted solution]

RANGESUM(Column(1), Column(2), Column(3)) - that's exactly what it does.

[Anonymous]

Well, that's a little better. I still wish there were a global setting that could be set in the script.