Changes

Jump to: navigation, search

Referencing Other Sections in XML Calculations

162 bytes added, 20:48, 2 December 2013
no edit summary
# 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 In the ''Content'' section of ''Cell Properties'', enter the reference to the Year 1 total for ''Staff'' using the following syntax: <br />=[''section ID''_'''total'''_''Node Name'']<br />In the above example, this will be ''=[1440_total_Year-1]<br />[[Image:XMLSampleReferenceInOverviewToStaffTotal.png|link=|600px]]
[[Category:XML]]
8,849
edits

Navigation menu