Recently we stumbled upon a strange issue - sometimes submitting a form through a mobile device (iOS) would lose one of the elements in a repeating section. The form is shown below and it is used to add amounts as needed. All amounts are summed in real time on the form. First there's a calculated field within the repeating section (formula is: "If(equals(currency,'BGN'),amount,0)" so that it adds only the chosen currency. And below the repeating section there's another calculated field that sums all corresponding currency fields.
So, the form, as seen from the capture, has calculated a larger amount (126230) while the 5 elements actually amount to a total of 105760. There has been a sixth element which is missing (not saved and submitted) but its amount somehow shows in the total.
If I open the form in edit mode the formula is being automatically recalculated correctly:
So far I have been unable to reproduce this issue (reported by users) - the test forms are always calculated correctly (as are most other forms in production).
Has anyone had that? Any ideas will be appreciated.
I checked the form and the Desktop layout was indeed left at "No" for the View mode (the mobile ones were set to "Yes" although I don't think it would matter much there). I changed it and can see the new value. But the calculated field also updates a value in a column (for reference or history) and I can still see the larger one. It couldn't have gotten this if there hadn't been another element to add to the value.
And I have 4 different users who insist they have input another element on different occasions yesterday.
so, does that mean your users added/deleted rows from repeating section but total sum didn't (both saved to the list field, as well as one you have seen before you switched on recalculation in VIEW) recalculate to reflect the most recent repeating section state?
first of all I would examine repeating section's XML to see what the real current content.
Regarding your question I'd say the sum did recalculate correctly but as if the element is missing . The users have paper documents (from which they input the data) to confirm the correct total sum.
I will try to check the XML, that's a good idea. There are 2 fields in the section and maybe the user skipped to fill in the first one (the name) and only filled in the second (amount) which somehow messed the data up.