Can't get numerical values to add

[RogerA]

Hi - i am trying to get several columns of data to add with no success.  I have the data as "double" and using a simple formula adding the columns together but its not working.  Any ideas?  Files attached.

[jasperlch · Accepted solution]

Hi, a Data Cleansing tool to convert all null values to zero is needed before performing summation in the Formula too because 1+Null will result in Null.