Hi Community,
I created a table with two columns and used “Add field from calculation” to combine (sum) those two columns into a “Total” column.
However, if one column has a null value, the “Total” column shows NaN. I want null values to be converted to 0 so that the “Total” column is calculated as Value 1 + Value 2 (null → 0) = Value 1.
I tried using data mapping, formatting fields to numbers, or adding or vector(0)
in the query… but it didn’t work. Null values can be displayed as 0 in the table, but the “Total” column still shows NaN (I think it maps null to a string “0” instead of a number).
Thanks