Pigment is a structured modeling platform. To guarantee accurate user data entry and consistent calculations, Pigment requires you to specify a data type for each input.
List of data types
Available data types for Metrics and List Properties include:
| Type | Description | Example |
| Number | Allows you to input numerical values with decimals. |
|
| Integer | Allows you to input numerical values without decimals. This format is useful when you want to ensure that Members input only non-decimal values. |
|
| Date | Limits input to dates only. The Member is asked to select a date. |
|
| Text | Allows you to input text, symbols and even emojis in cells. |
|
| Dimension | Allows Members to select an Item from a Dimension list. This data type is key when it comes to grouping, allocating, and mapping data. |
|
| Boolean | Supports TRUE or FALSE values. It is displayed as a checkbox in the grid. There are three Boolean states: TRUE, FALSE, and BLANK. Blank and FALSE values may appear similar, but FALSE values feature an outlined checkbox. BLANK values are entirely grayed out. |
|
| Access Rights | Allows you to give read/write rights to Members. This data type is useful when you manage access rights within your Application. | - |
| Permissions | Allows you to adjust Board permissions for Members in your Application. |
|
How do the different data types work together? Below is a list of the data type compatibility in Pigment:
-
Number and Integer are compatible without specific functions.
If you enter a decimal where data type is listed as Integer, it is automatically truncated.
-
Number and Integer can be used in the formula of a Text object without any functions, though the TEXT function can also be used.
-
Boolean can be used in the Text object. It returns the words TRUE or FALSE.
-
To convert Text to Number or Integer, you need to use the VALUE function.
-
To convert Text to Date, use the DATE function.