---
title: "New-Adding a Simple Expression to a Pivot Report"
slug: "new-adding-a-simple-expression-to-a-pivot-report"
updated: 2024-10-17T09:33:42Z
published: 2024-10-17T09:33:42Z
canonical: "docs.avontus.com/new-adding-a-simple-expression-to-a-pivot-report"
---

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

# Adding a Simple Expression to a Pivot Report

The procedures below introduce you to the Expression Editor by showing you how to create a simple expression. For this, we use the Product Pricing Pivot and add a Total Quantity expression to it. The basic procedures in this article apply to any expression you create, no matter how complex.

To add a simple expression to a pivot report:

1. Launch the appropriate pivot report.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695388692610.png)
2. As necessary, edit the pivot report.
3. Click **Add Expression**.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695388834328.png)

The *Add Expression* dialog appears.
4. Click in the **Field Name** text field and enter Total Quantity.
5. Click the **Data Type** dropdown and select **Integer**.
6. Click the **Formula** button ( ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/6cacc433-dc96-48b5-ae03-455a07fc2d26.png)).

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695389005597.png)

The *Expression Editor* dialog appears, with the **Fields** item pre-selected.
7. Scroll down the list in the bottom-center column and double click **Quantity Available**. [Quantity Available] appears in the text field in the top of the Expression Editor.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695389069987.png)
8. Click **Operators** in the bottom-left column of the Expression Editor. The center column refreshes, displaying available operators.
9. Scroll down the list in the bottom-center column and double click the plus sign (+). The Expression Editor adds the plus sign to the top text field.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695389141056.png)

> **Note:** The Expression Editor displays the words *Syntax Error* because the expression is not yet complete.
10. Click **Fields** in the bottom-left column of the Expression Editor. The center column refreshes, displaying available operators.
11. Scroll down the list in the bottom-center column and double-click **Quantity On Rent**. The Expression Editor adds [Quantity on Rent] to the top text field.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695389255021.png)
12. Click **OK**.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695389279624.png)

The *Add Expression* dialog returns, containing the expression in the **Formula** text field.
13. Click **OK**.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695389328290.png)

The Pricing Pivot returns, containing the new field.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695389369057.png)