Calculation column

I wish to make calculations based on responses from previous questions. But the challenge I am faced with is that, I only get results from the formula if all previous responses related to the questions are answered. I would want to get results even if some questions were skipped given that they are not applicable.
I would be glad if I was assisted in this regard.

In my example a parent is asked the kind of expenses made on children. Which is a multiple select questions, so I want to calculate the Total expenses based on the selected expenses kind. Thank you.Forum.xlsx (11.5 KB)

We have a section on the docs that discusses using empty values in math and some workarounds. https://docs.opendatakit.org/form-logic/#empty-values-in-math

1 Like