---
title: "Using the Expression Editor"
slug: "using-the-expression-editor"
updated: 2024-07-30T12:47:34Z
published: 2024-07-30T12:47:34Z
canonical: "docs.avontus.com/using-the-expression-editor"
---

> ## 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.

# Using the Expression Editor

The Expression Editor enables you to create and edit various Boolean or regular expressions in controls. An expression is a string that, when parsed and processed, evaluates some value.

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

Expressions consist of column/field names, constants, operators and functions. Column/field names must be wrapped with brackets. The following are examples of regular expressions:

*"[Quantity] * [UnitPrice] * (1 - [BonusAmount])"*

Boolean expressions:

*"[Country] == 'USA'"*

You can enter or edit expressions manually or use the Editor's controls to select functions, operators, fields and constants. To do this, click a category, which exposes a list of functions, operators, fields or constants that you can select. The Expression Editor supports numerous standard functions, enabling you to easily perform different string, date-time, logical and math operations over data. You can access the available functions by selecting the Functions category.

The following pivot reports enable you to add one or more expressions to your report:

- Product Pricing Pivot
- Product Quantity Pivot
- Scaffold Pivot
- Activity Pivot
- Inspections Due for Non-Completed Scaffolds Pivot

## Accessing the Expression Editor

To access the Expression editor:

1. Under Reports, select Product Pricing Pivot

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695387559420.png)
2. Select **Add Expression**

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-1695387584569.png)
3. Enter a Field Name
4. Select a Data Type
5. Click ...

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

The Expression Editor will appear.

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