Export (0) Print
Expand All
Expand Minimize

calculations Element

Office 2007

Contains definitions for calculations performed in the form and specifies how blank values are handled.

Type

xsd:complexType

Child Elements

ElementDescription
calculatedFieldDefines an individual calculation, including the formula, when the calculation is to be performed, and where the result will be stored.

Attributes

AttributeTypeRequiredDescriptionPossible Values
treatBlankValueAsZero
xsf:xdYesNo
NoSpecifies whether a blank field should be calculated with a value of zero. Default is yes.
  • yes
  • no
xsf:xdYesNo

Definition

<xsd:element name="calculations">
  <xsd:complexType>
    <xsd:sequence>
      <xsd:element ref="xsf:calculatedField" minOccurs="0" maxOccurs="unbounded"/>
    </xsd:sequence>
    <xsd:attribute name="treatBlankValueAsZero" type="xsf:xdYesNo" use="optional"></xsd:attribute>
  </xsd:complexType>
</xsd:element>

Remarks

Every calculation in the form will have a calculatedField element.

Example

The following is an example of the calculations element:

<xsf:calculations>
 <xsf:calculatedField
  target="/my:myFields/my:average"
  expression="xdMath:Avg(../my:expenses/my:expense/my:amount)"
  refresh="onChange" />
</xsf:calculations>


Community Additions

ADD
Show:
© 2014 Microsoft