treatBlankValueAsZero Attribute
Specifies whether a blank field should be calculated with a value of zero.
Type
xsf:xdYesNo
Parent Elements
| Element | Description |
|---|---|
| calculations | Contains 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".
Note This item is not supported when the Disable Service Pack features option on the Advanced tab of the Options dialog box in InfoPath is selected or when Microsoft Office 2003 Editions Service Pack 1 or later is not installed. Any form defined by a form definition file (.xsf) that includes this item cannot be opened in InfoPath when service pack features are disabled or unavailable.
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>