Coalesce is resulting in 0

[Kal_Lam]

Welcome to the community, @Derek1! This post discussed previously should help you understand more about using coalesce:

Question about the max function and missing value

You could do it as outlined in the image shared below. In the survey tab of your xlsform: [Image 1] Data entry screen as seen in Enketo: when all the variables are filled [Image 2] Data entry screen as seen in Enketo: when some of the variables are missing [Image 3] Reference xlsform: Maximum.xlsx (9.7 KB)