Difference between revisions of "Referencing Other Sections in XML Calculations"

From SmartWiki
Jump to: navigation, search
Line 5: Line 5:
 
In the example above, the ''Overview'' section contains the totals of the values entered under the ''Staff'' and ''Equipment'' sections.  
 
In the example above, the ''Overview'' section contains the totals of the values entered under the ''Staff'' and ''Equipment'' sections.  
  
To create these total references:
+
To create these total and subtotal references:
 
# Edit the {{XML}}
 
# Edit the {{XML}}
 
# Click on the [[XML Section Builder|Section Builder]] button<br />You will see the list of Sections at the left.<br />[[Image:XMLSections.png|link=|350px]]
 
# Click on the [[XML Section Builder|Section Builder]] button<br />You will see the list of Sections at the left.<br />[[Image:XMLSections.png|link=|350px]]
 
+
# 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]]
[[Image:LocationOfXMLSectionID.png|link=|700px]]
 
 
[[Category:XML]]
 
[[Category:XML]]

Revision as of 14:46, 2 December 2013

The following is a step-by-step walkthrough of creating an XML worksheet that calculates the totals across sections.

XMLExample-Cross-SectionReferences.png

In the example above, the Overview section contains the totals of the values entered under the Staff and Equipment sections.

To create these total and subtotal references:

  1. Edit the XML custom field
  2. Click on the Section Builder button
    You will see the list of Sections at the left.
    XMLSections.png
  3. Find the Section ID of each section to be referenced (in this example, Staff and Equipment, by floating your cursor over the section name:
    LocationOfXMLSectionID.png