Currency

Currency fields are used to store a monetary value. By using currency fields, you can store values that can be reported on later as well as used in custom calculations. For example, you might set a bonus rate on the User Demographic form that could later be used to calculate bonus payments using either calculated fields or by downloading the data to Microsoft Excel.

You need to establish the field size, which is the total field length including the decimal character, and the Decimal positions, indicating the number of digits to the right of the decimal.

Currency custom fields have the following additional properties:

• Field size — This is the number of digits you can type including any separator characters. For example, “1,000,000.11” takes a Field size of 12.

  Note:

  Comma separators are stripped, so “1,000,000.11” is displayed as “1000000.11”.

• Decimal positions — This is the number of digits that are saved after the decimal point.

  Note:

  Rounding is applied if you type more digits than specified. For example, if you set Decimal positions to 2, then “55.756” will be saved as “55.76”.

• Required — If checked the field is required on the form and the form cannot to be saved without supplying a value.

See Creating and Modifying Custom Fields for more details.

For the full list of types, see Custom Field Types.