Calculate Total even in some fields have NULL values

Hi:

I have a data set that contains four numeric fields (double).

The example data set includes 18 records where:

a. Record #8 is the single record which contains values across all four fields.

b. Per a., the calculated field "Total" correctly shows value = 34.

c. However, for the remaining 17 records, I only have a value in either one of the four fields.

d. Per d., the "Total" shows only [Null] as part of the calculation.

How should I tweak the formula so that "Total" shows the correct value... regardless how many of the 4 fields are populated?

Thank you,

Tom

Expression

Accepted answers

Theres prob better way to do this but see if this works

All comments

Theres prob better way to do this but see if this works

Works like a charm. Any thoughts as to why the originally posted process did NOT work? What did I miss?

@TomBock Ah thats a good question. I believe because your fields have null values hence you cant add. That also got me thinking and heres another much easier way to do is basically turn the null value to empty and then add all the columns

Excellent alternative!! Thank you so much for the assistance... I very much appreciate it.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703