# Measure format

This section describes the formatting options available for measures in Finance Tables.

### **Measure style**

* **Decimal:** Display the value as a decimal number.
* **Currency:** Display the value as a currency.
* **Percent:** Display the value as a percentage.
* **Time (ms):** Display the value as a time value in milliseconds.

### **Quick Table Calculation**

* **None**
* **Percent of total**

When **Percent of total** is selected, Finance Tables will format the result as a percentage.

### **Precision**

* **None**
* **K**
* **M**
* **B**
* **T**

> If **IBCS** **Auto format** is enabled, manual number format settings such as precision can be overridden.

### **Value formatting**

#### **Positive Values**

Choose how positive values should be displayed:

* **1234**
* **+1234**
* **(1234)**
* **(+1234)**
* **1234+**

#### **Negative Values**

Choose how negative values should be displayed:

* **-1234**
* **(1234)**
* **(-1234)**
* **1234-**
* **1234**

<figure><img src="/files/Yjg6VpFD6jrmln6XV1uO" alt=""><figcaption></figcaption></figure>

### **Currency**

When **Measure style** is set to **Currency**, you can define:

* **Currency:** The currency code, for example `USD` or `EUR`.

<figure><img src="/files/KRl4r9wV9Re9YsgQ2bLc" alt=""><figcaption></figcaption></figure>

### **Time format**

When **Measure style** is set to **Time (ms)**, you can define the time range formatting.

### **Number formatting**

For non-time measures, the following options are available:

* **Decimal places**
* **Prefix**
* **Suffix**
* **Replace null values**
* **Include thousands separator**

### **Column layout**

The following layout settings are also available:

* **Default aggregation when grouping**
* **Column alignment**
* **Column header alignment**
* **Header tooltip**


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.infotopics.com/finance-tables/configuration/configuration-screen/data-tab/measures/measure-format.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.