This documentation is archived and is not being maintained.

treatBlankValueAsZero Attribute

Office 2007

Specifies whether a blank field should be calculated with a value of zero.

Type

xsf:xdYesNo

Parent Elements

ElementDescription
calculationsContains definitions for calculations performed in the form, and specifies how blank values are handled.

Definition

<xsd:attribute name="treatBlankValueAsZero" type="xsf:xdYesNo" use="optional"></xsd:attribute>

Remarks

Default is "yes".

Example

The following is an example of the treatBlankValueAsZero attribute as it is used in the calculations element:

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


Show: