This question already has an answer here:
I need to converte NULL values to 0 values with the overall goal of sum up two columns in attribute table in QGIS. Since one of these colums has NULL values, the new column with the sum also appears with NULL value (instead of preserving numeric value of other column).
I have tried Selecting column by all NULL value and putting 0 in Expression Field but that does not work.
Any ideas on how to do it?