AnsweredAssumed Answered

Can you compare two fields with the same name in the repeat?

Question asked by shelley.schulte_ndor on Jan 14, 2019
Latest reply on Jan 24, 2019 by shelley.schulte_ndor

I am essentially trying to compare the same field in the same repeat.  The problem I am running into is that the field has the same name, thus I have no idea how to compare it in a calculation.  For example, I want to enter a number in AbsPerCoverShrub, then within my repeat I will make another entry and enter it again.  After that I'd like to compare the 2 numbers.  You can do this type of thing in excel because each cell has it's own name.  But can you do this in survey123 since the numbers are stored in tables with no name assigned to each table cell?

 

Above you will see the first entry is 95, then the next entry is 5 (done in a repeat). How then do I compare in the xlsform?  Like if 95 > 5 then true.  But the fields have the same name.

Outcomes