I have a Repeating Section where I'm capturing KM's Traveled for multiple trips. I need to extract that amount(KMTravelled) for each line in the repeating section and then add it all up.
I'm storing the XML in a multi-line column in my list, I want to query that XML and get all the KMTravelled field values and then add them all up. I've tried collections and a for-loop on that but I always get the first value only.
Any help would be appreciated.
Thanks in advance.