Decimal Number Property Type
The decimal number property data type is used to store a numeric value with a fractional component. The definable behaviors of a decimal number property include standard or NIST rounding, precision, and significant digit math options.
Values stored in a decimal property can contain values with a precision of up to 20 places past the decimal point. The values may be positive or negative.
Decimal Number Property Attributes
- Name: This is the unique identifier for the property definition. This value must be unique among all properties within the same parent definition.
- Display Name: This attribute sets the default display name to label or otherwise identify the property value on the Agentry Client. This will also be the default label for any screen control that displays this property.
- Minimum Value: This is the smallest value that may be contained within the property. This attribute and the Precision attribute are interdependent. You cannot specify a minimum value with more decimal places than is specified in the Precision attribute. To force the value to be positive, set the this attribute to 0. The minimum value specified here can be no greater than the defined Maximum Value.
- Maximum Value: This is the maximum value that the decimal property can contain. This is dependant on the Precision attribute. You cannot specify a maximum value with more decimal places than is specified in the Precision attribute. The value defined here can be no less than the defined Minimum Value.
- Precision: This attribute specifies the maximum number of places past the decimal point. A negative precision indicates places before the decimal, with any values past this point padded with zeroes. A precision of 0 specified whole numbers only, though consider using an integral number property for this purpose.
- Blank - This is a Boolean attribute that specifies whether to display a blank for the property when it has a value of 0.
- Math: This is a Boolean attribute that specifies whether or not to use significant figure math in any calculations that use the property value.
- Rounding: This attribute specifies the rounding method to use when this value is rounded. This may occur within rule definitions (ROUND function term) or when calculations involving this property are performed. The resulting value for the property will be rounded to the defined precision, as well as based on the significant digits operations. The methods for rounding are Nearest or NIST. Nearest is the typical rounding method in which the digit immediately after the digit to be rounded determines value of that rounded digit. Values below 5 leave the digit unchanged. Values 5 or above increment the rounded digit by 1. The NIST rounding method rounds values according to the rules set forth by the National Institute of Standards and Technology, specifically as they relate to calibrations measurements.