treatBlankValueAsZero Attribute

  • Article

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".

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>