Numeric Columns

A Numeric column can contain a variety of data, such as product quantities, tax rates, product prices, or supplier rating levels. TeamDesk allows configuring numeric columns specific properties for organizing your data in a proper way.

General Properties

Numeric Column General

If a column contains data that doesn’t appear or behave as desired, you can edit the column’s General Properties and the properties defined by the column type.

Numeric Options

Numeric options

Properties defined by the column type:

Type
This property allows a user to set or change the numeric type of a column. The following values are available:
Decimal places
This property allows a user to specify the number of decimal places for a numeral value.
Units
This property allows a user to specify the measurement units in which the column value will be presented.
Unit position
This property allows a user to add a character of a unit, in which the value of the field is represented, to a specific position. The following values are possible:
Data Entry
This property allows a user to set additional display attributes for a numeric field:
Choices
This field is unrolled, when the Drop Down or Radio Buttons option is selected. To make up the list of choice, type in necessary entries in the Choices field.

Please note that each new entry should start on a new line. No punctuation marks are required.

Choices example

Totals
This property allows a user to view the total for all column entries; select the check box if you want the Totals line to be present at the end of the table;
Averages
This property allows a user to view the average for all column entries; select the check box if you want the Averages line to be present at the end of the table;
Zero Values
When this property is unchecked, blank values are displayed instead of zero values. Also it affects the average calculation as zero and blank values are ignored. If the property is checked, zero values are visible, moreover, they are taken into account when the average is calculated;
Use digit grouping
This property allows a user to specify the way a numeral value should be represented. Select the Use digit grouping check box if you want to group digits of numeric values by thousands.

Advanced Options

Advanced options

Colorization
You can use colorization to draw users’ attention to specific numeric values. The colorization is based on the conditions whether a value is less than an indicated number. Also, a color of an alternative value can be specified in the “otherwise” field.

More details about the colorization you may read here.

Help
When the Help text property is filled in, the question mark is displayed near the field name on the View/Edit form. If you point to this question mark, the pop-up with a tip or a help text message will be shown.