Thank you!
I wrapped my initial formula in the once() operator and that did the trick.
The way I understand it, the once() checks whether the value is empty and if it is, passes on the expression within the brackets. Once the user enters a value, ODK passes on without doing the calculation. As a result I can save without the ‘’ in the formula deleting the data that was entered.
Here’s a copy of the xls if it can help anyone out there!
dynamic_default_test.xlsx (17.6 KB)
