In this column, I have grouped the XML based on the GroupID element by using the generate-id() function. This generates unique keys used for indexing the key value. The key value is GroupID.
All the PV values of each groupID is then added and the sum is formatted till six decimal values.Here’s the XSLT file:
The groupID is = |
| Sum is =
Now, input the XML file:
244133L 244133L_EUR_STUB -11121619.203 325866L 325866L_EUR_STUB -12121619.2938 325867L 325867L_EUR_STUB -14121619.293864 502722L 502722L_EUR_STUB -13121543.293643 502722L 502722L_PLN_STUB -11234329.698236 325866L 506593L_EUR_STUB -11134543.12963 244133L 542056L_EUR_STUB -12342342.769823 325867L 553257L_PLN_STUB -98745908.128361 570079L 570079L -64325623.693286 570079L 570084L_EUR_STUB -67824233.986723 244133L 570090L -56721463.972345 325866L 570096L -87623763.23442 325867L 570098L -79843267.4232 244133L 570099L -87246234.23423 325866L 570106L -32423896.4732