Hi there,
I've created a form with related "sum" calculation fields in Survey123 Web Designer, but the calculations are not registering/showing up in the data table once the form is submitted despite the *pre-submitted* calculation values being visible. I am unsure what to do since the calculations clearly CAN function properly, but aren't... I've attached a video, and also tried to describe below.
There are 2 fields with calculations in the form:
- # Clustered Monarchs (total) --> Sum of "clustered" monarch butterflies
- this field is conditional and shows only if someone marks that they observed clustered monarchs, and all the fields referenced in the calculation are conditional.
- GRAND TOTAL: Monarch Butterflies -->Sum of all monarch butterflies to produce "grand total" (sum of clustered butterflies from calculation above + fliers + sunners + loners + grounders fields)
- this field is NOT conditional, but all the fields referenced in the calculation are.
Both of these fields are set to "Read-only" and have default values of 0. The fields referenced in both calculations have default values of 0, and are all conditional questions.
When I am in the "Preview" view of "Design" mode and when I select "open in browser" to test out my form, I can see the correct auto-calculated values populating the two calculated fields prior to submitting. However, once I submit the form (successfully, no notes or warnings), the calculated field values do not show up in the "Data" table.
Additionally, when I am testing out my form in the Survey123 Field App, I cannot see the two auto-calculating values (they do not populate/function in the app) prior to submitting. And, as before, the calculated field values do not show up in the "Data" table.
Can anyone help? Is there an error I can correct or a setting I can change? Or, is this a glitch?
*VIDEO CORRECTION - at min 5:20 I accidentally highlighted the wrong field. I meant to say that the 2 calculated fields are showing up as blank in the field app (in the vid I had highlighted the 1st cluster total, rather than the "# Clustered Monarchs (total)").
