I am having issues with sum function. The below is XML I have. I am combining all XML records into single document and then I am passing amount value to sum function, but we get the following error. I believe it is the XML structure (shown below) is the cause of it. Can anyone provide feedback?
XML I have is below
<payment/> --- > Please note that in the first transaction element payment element comes like so.
<payment> -- In the second iteration of transaction I get payment as we need and we are passing the amount field below to sum function.
<transaction_description>Sale - Approved No Processor</transaction_description>