I have got this problem when checking my XLS form from the online validator

There’s a few issues with your form. First, there appears to be a couple unterminated groups right at the end:

Next, you appear to be calculating the sum() of various values entered during a repeat, however you are doing these calculation inside the repeat group (!), whereas any calculations aggregating all the values of a repeat - eg sum, min(), max() - must appear outside (and intuitively after) the repeat. I suspect this is what is actually throwing the cryptic errors you are seeing.

Have a look at the examples in the sum function documentation for how these calculations should be laid out. There’s also a good example here (courtesy @Kal_Lam): Income calculation inside a repeat group - #17 by Kal_Lam

I might also suggest validating your form before trying to deploy it, to save you some time. This will quickly pickup these form issues.

2 Likes