---
title: "Learn How to Use Different Data Types in Pigment"
slug: "data-types-in-pigment"
description: "Understand the different data types in Pigment, such as Text, Number, Boolean, and more. Learn how to use them to structure your models efficiently."
updated: 2026-01-20T14:11:33Z
published: 2026-01-20T14:11:33Z
canonical: "kb.pigment.com/data-types-in-pigment"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Data Types in Pigment

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. | `1,234.56` |
| #### **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. | `1,234` |
| #### **Date** | Limits input to dates only. The Member is asked to select a date. | `31/12/2021` |
| #### **Text** | Allows you to input text, symbols and even emojis in cells. | `ABC` |
| #### **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. | `France` `Product 1` `Employee A` |
| #### **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. | `No access` `Can Configure` `Can Comment` `Can open` |

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.

> [!WARNING]
> If you enter a decimal where data type is listed as **Integer**, it is automatically truncated.
- For very large numbers, such as those with 10^14 digits, **Integer** is more performant than **Number**. Consider switching to **Integer**.
- **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.

### **More information**

- [Set up Properties in Lists](/v1/docs/set-up-properties-in-lists)
- [Measure Data with Metrics](/v1/docs/measure-data-metrics)