Using Calculate field to add multiple fields but it wont return value unless all fields have value

Question

I am trying to add 6 fields together but for some reason the formula doesnt display a result unless all of the fields have a value. Is there a way to make it return a value even if some of the fields are currently empty since they may not always be used?

dougbrowning · Accepted Answer

Yes you can use coalesce.  Example  coalesce($field}, 0)  This happens because a empty field gets '' empty string then the math fails.

coalesce(value1, value2)

Returns the first nonempty value. This function supports only two values.

coalesce(${question_one}, ${question_two})

Bookmark this page its super handy   https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm