R
rdra90
I'm trying to add three numeric fields together in a query. Some of the
fields will have null values (in this context, the same a zero) from time to
time. Because of "null propagation," I get a null sum if any one of the
three fields is null. I want the sum of the available field values even if
one or more is blank. How do I do this?
fields will have null values (in this context, the same a zero) from time to
time. Because of "null propagation," I get a null sum if any one of the
three fields is null. I want the sum of the available field values even if
one or more is blank. How do I do this?