Hello community, I am creating a form in which sales are recorded, what I want is to accumulate the registered sales, I am using sum(${field1}) to accumulate sales by products and it gives me a "partial" total for each record that I am entering and sending, but it does not work for me when I want to know the total value of all registered sales
Welcome to the ODK forum, @calhuay! We're glad you're here. When you get a chance, please introduce yourself on this forum thread. I'd also encourage you to add a picture as your avatar because it helps build community!
When you say "the total value of all registered sales" do you mean within your currently open survey, or across all submissions to the server? Can you attach your form here for troubleshooting?
Please take a look at the example here to make sure you are following the right pattern for using the sum() function: https://docs.getodk.org/form-operators-functions/#sum
In particular, your target field should be within a repeat group.