I have created a form which then has a selection of dropdowns, based on the users dropdown choice it will then apply a numeric value to a calculated field, what I would like to do is then sum these fields.
The use has answered questions 1 & 3 but has left question 2 unanswered.
The total then shows, which is very odd as I would expect it to sum the total regardless of whether Question 2 has been answered