Changes

Jump to: navigation, search

Referencing Other Sections in XML Calculations

1 byte added, 22:08, 10 November 2014
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.
# 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]#You may also use @section.sectionname.id@ to avoid hard-coding section IDs<br />[[Image:XMLSampleReferenceInOverviewToStaffTotal.png|link=|600px]]**You may also use @section.sectionname.id@ to avoid hard-coding section IDs
# Repeat for each section total to be referenced.
0
edits

Navigation menu