---
title: "Example: Using Formulas in Decision Tables"
slug: "example-using-formulas-in-decision-tables"
updated: 2024-09-16T19:11:11Z
published: 2024-09-16T19:11:11Z
canonical: "docs.processmaker.com/example-using-formulas-in-decision-tables"
---

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

# Example: Using Formulas in Decision Tables

## Overview

> [!NOTE]
> **Intended audience:** Process Owners and Designers
> 
> **Tags:** Decision Table; Request Variables; Formulas

This example show how to use formulas in a Decision table. The Decision table used in this example has four input columns: Gross Income, Credit Score, Loan Amount Requested, and Net Income. The table also has one output column: Approval Status.

![](https://cdn.document360.io/2d311614-fcb7-4424-8b4c-d4d3091eebeb/Images/Documentation/a2041b81-372d-4271-bd4e-f35f25861384.png)

Click on the following link to download this Decision Table.

[Loan Approval.zip](https://cdn.document360.io/2d311614-fcb7-4424-8b4c-d4d3091eebeb/Images/Documentation/Loan%20Approval.zip)

Follow these steps to import and use this Decision Table:

1. [View all Decision Tables](/v1/docs/decision-tables#view-all-decision-tables).
2. Click the **Import** button. The **Import Decision Table** displays. ![](https://processmaker.gitbook.io/~gitbook/image?url=https%3A%2F%2Fprocessmaker.gitbook.io%2F%7Egitbook%2Fimage%3Furl%3Dhttps%253A%252F%252Fcontent.gitbook.com%252Fcontent%252F09GreG9x1Y6qRGRu9MvR%252Fblobs%252FXxtYV1pPkycyb1KomM8a%252FImport%252520Decision%252520Table%252520from%252520page%252520not%252520Editor%252520-%252520Designer.png%26width%3D300%26dpr%3D4%26quality%3D100%26sign%3Dcad32e6674d24be81d3c4f634f3c4ee3ca1f3983d564bc87bc85f22253ce776d&width=300&dpr=4&quality=100&sign=accfb823&sv=1)
3. Click **Browse** to locate the downloaded Decision Table.
4. Click **Import**. The **Import Decision Table** screen displays to indicate that the Decision Table imported correctly.
5. From the list of Decision tables, click the ![](https://cdn.document360.io/2d311614-fcb7-4424-8b4c-d4d3091eebeb/Images/Documentation/5f7d7b93-9e90-41d9-b528-751bf05f054f.png)menu next to the table just created, and select **Edit** to open the Decision Table for editing.

![](https://cdn.document360.io/2d311614-fcb7-4424-8b4c-d4d3091eebeb/Images/Documentation/546083d9-716a-4299-afb6-be51e2a1cc3e.png)
6. Click on the formula icon ![](https://cdn.document360.io/2d311614-fcb7-4424-8b4c-d4d3091eebeb/Images/Documentation/8ae04968-00b5-4665-9bf4-b09d6d359d7e.png) to view the formula defined on this column. This formula uses Request Variables, **income** and **tax**, which are part of the JSON data for the request.

![](https://cdn.document360.io/2d311614-fcb7-4424-8b4c-d4d3091eebeb/Images/Documentation/4e3311cc-617b-4c05-8dde-35bd609f5c16.png)
7. From the **Preview** options on the right, select **Sample Input** to test the Decision Table.
8. Enter the following JSON data.

```plaintext
{
   "income": "1000", 
   "score": "600", 
   "amount": "1500", 
   "tax":0.07 
}
```

1. Click **Run** to test the table. The table output will be shown in the **Output** section.

![](https://cdn.document360.io/2d311614-fcb7-4424-8b4c-d4d3091eebeb/Images/Documentation/800c6d04-ab84-4011-810b-fb2f68e46a26.png)
2. Modify the JSON as needed to try out different input values.
3. [Insert a Decision Task into a process and configure properties](/v1/docs/decision-task-connector) to use Decision Tables in your processes.

![](https://cdn.document360.io/2d311614-fcb7-4424-8b4c-d4d3091eebeb/Images/Documentation/0c324505-cb95-4092-b523-3b8231ed64cc.png)

Variable Mapping for a Decision Task