Numeric Columns

A Numeric column may contain a variety of data. For example: a quantity of products, tax rate, product price or supplier rating level. TeamDesk allows configuring numeric columns specific properties for organizing your data in a proper way.

If a column comprises the data that don't look or behave the way you want, you may edit column General Properties and the properties defined by the column type.

General Properties:

Numeric Column General.png


Properties defined by the column type:

Graphical user interface, application

Description automatically generated


Choices Data Entry

To simplify the data entry process, the Numeric Column can be presented as a list of numeric entries to choose from. To create the Choices Numeric Column, set the Drop Down or Radio Buttons option and type in necessary entries in the unrolled Choices field. (Note that every new entry should begin with a new line. No punctuation marks are required.)

Graphical user interface, text

Description automatically generated


There are 4 kinds of Numeric Columns (Simple number, Currency, Percent and Rating). Changing the options will help you to display numbers precisely, calculate total or average number and specify the form of data entry.

Numeric Options

Column Property

Description

Type

This property allows a user to set or change the numeric type of a column. The following values are available:

  • Simple number
  • Currency
  • Percent
  • Rating

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:

  • Left Side
  • Between sign and number
  • Right Side

Data Entry

This property allows a user to set additional display attributes for a numeric field:

  • Select the Type-in option if you want the column to be presented as a simple text field.
  • Type-In-Numeric.png
  • Select the Drop Down (with None) if you want the list of entries to be presented as a drop-down list with the None choice in the list;

Numeric-Column-choices.png

  • Select the Radio Buttons (without None) option if you want the list of entries to be presented as radio buttons with the only possible choice in the list;

Numeric-Choices-Dropdown.png

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. (Note that every new entry should begin with a new line. No punctuation marks are required.)

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

Graphical user interface

Description automatically generated

Column Property

Description

Colorization

To draw users’ attention to some numeric values, you can colorize them. 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. Moreover, you can apply Colorization in Formula-Numeric columns. 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.

Next: Date Columns