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.
When displayed or converted to text, the numeric format is automatically determined based on the
Language and Location
settings specified in the user profile.
In cases where the data is accessed by someone who is not a database user, theLanguage and Location
settings specified in the database properties are used to determine the text representation of the numeric.
General Properties
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
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:
- Simple number: used to store and display numerical values without any specific formatting. It’s suitable for general numeric data such as counts, quantities, or measurements;
- Currency: designed for storing and formatting monetary values. It typically includes currency symbols or codes, making it ideal for financial data, pricing, and expenses;
- Percent: used for storing and displaying values as percentages, represented by the symbol (%). It’s commonly used to show proportions or ratios relative to 100, such as tax rates or success percentages;
- Rating: used to capture and present qualitative assessments or evaluations. It often uses symbols like stars or numerical values to indicate the quality or performance of items, such as product ratings or movie reviews.
- Decimal places
- This property allows a user to specify the number of decimal places for a numeral value.
- Units
- This property allows users to specify measurement units or descriptive text that will be displayed alongside the numeric value in the column. For example, if you want the column to display values such as "36 months" or "10 kg," set the
Units
property to "months" or "kg." The specified units will appear next to the numeric value in views, forms, and reports, providing a clear context for the data. - Unit position
- This property allows users to define where the unit of measurement or descriptive text will appear in relation to the numeric value in the field. The following options are available:
- Left Side: The unit appears before the numeric value (e.g., "$100" or "kg 10").
- Between Sign and Number: The unit is placed between a sign (e.g., "+" or "-") and the numeric value (e.g., "+kg 10" or "-$100").
- Right Side: The unit appears after the numeric value (e.g., "100 kg" or "100 months").
- Data Entry
- This property allows a user to set additional display attributes for a numeric field:
-
Type-in: select the Type-in option if you want the column to be presented as a simple text field;
-
Drop Down: 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;
-
Radio Buttons: 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.
The
Radio Buttons
data entry does not support undefined or blank option. If you need an undefined (null
) value, consider setting theData Entry
property toDrop Down
.
- 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.
- 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 view or Timeline view;
- 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 view or Timeline view;
- 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
- 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.