thousands-sep is just one of the appearances we use in ODK Collect. That means it's just used to display answers in a form in a particular way. When you save a form your answers are normal, without any separators so you can calculate those values like it didn't use that appearance.
As I understand you probably want to calculate those values and then again display with thousands-sep. Since we support that appearance only in case of number widgets you need to display the result in such a widget as well. It would look like this:
thousands-sep.xlsx (7.9 KB)
2 Likes