Select to view content in your preferred language

Error on summing up an indexed-repeat equation

306
2
Jump to solution
03-25-2024 10:24 AM
DanaYoung
Regular Contributor

I'm new at creating equations in xls format and I'm struggle with getting this equation to function for a survey in survey 123.

I get this error in survey 123 : "TypeError: Value is undefined and could not be converted to an object in expression: sum(indexed-repeat( /Form_1/bio/biological_control_agent/bioamt , /Form_1/bio , position (..)))"

The equation is: sum(indexed-repeat(${bioamt}, ${bio}, position (..)))

The table below is a copy from the form I'm working with (maybe I don't' have the layout correct?)

DanaYoung_0-1711387330393.png

Any help or insight would be greatly appreciated. 

 

0 Kudos
1 Solution

Accepted Solutions
DougBrowning
MVP Esteemed Contributor

indexed repeat returns just one value so cannot sum it.  If you just want to sum the values of the repeat simply

sum(${bioamt})

is enough

View solution in original post

2 Replies
DougBrowning
MVP Esteemed Contributor

indexed repeat returns just one value so cannot sum it.  If you just want to sum the values of the repeat simply

sum(${bioamt})

is enough

DanaYoung
Regular Contributor

Thank you! Of course it's something simple, but then again I was coping this form used for a different application, so thought it would be similar in equations, but apparently not.