Changes

Referencing Other Sections in XML Calculations

293 bytes added, 20:47, 2 December 2013
no edit summary
# Find the Section ID of each section to be referenced (in this example, ''Staff'' and ''Equipment''), by floating your cursor over the section name:<br />[[Image:LocationOfXMLSectionID.png|link=|700px]]<br />The Section ID will be contained in the URL shown at the bottom of the page.<br />The Section ID of the ''Staff'' section in this example is ''1440''.
# Click into the ''Staff'' section and then into the column heading of the first row whose total should be referenced.<br />Take note of the ''Node Name''.<br />Also note that the ''Has Total'' option has been selected.<br />[[Image:XMLExample-StaffNodeName.png|link=|600px]]
# Now click into the ''Overview'' section and click into the node that should contain the total for Year 1 from the ''Staff'' section.
# Enter the reference to the Year 1 total for ''Staff'' using the following syntax: <br />
[[Image:XMLSampleReferenceInOverviewToStaffTotal.png|link=|600px]]
[[Category:XML]]
8,849
edits