we can use Cumulative Sum functoid for each repeated record and add the result before sending to the destination element
XSLT : Cummulative Sum
I need to do a sum within biztalk map or custom xslt. The sum of different field from different records should be calculated only for providers listed within the 'TotalAmount' Element.
I would appreciate any help. Thanks!
Here is the sample Input XML and output XML.
<Electricity> ----Repeat Record
<Water> ---- Repeat Record
<ETax>-- Repeat Record
<WTax> --Repeat Record
<Header> ---- no repeat record
Sign in to comment
0 additional answers
Sort by: Most helpful