I am needing to get percentages from an xml file into another xml file.
Here is a snippet of the in file(there will be hundreds of the <pavement_x0020_Conditions> nodes in the real file):
and here is a snippet of how I need it to look:
Basically I need to know how to pull all the areas for all types (e.g., AC, PCC) add them, and figure a percentage for each. I actually know how to pull each type's area and add it with the Sum() function (I think), it's the percentage that I am having trouble with.
Thanks in advance.