Exago Logo
Search
Generic filters
Exact matches only

ExpressView: Formula Columns

Notice

This article applies to the ExpressView Designer in pre-v2021.1. For v2021.1+, refer to the ExpressView: Introduction (v2021.1+) article.

 

Formulas can be used to create custom data columns in ExpressView. Formulas are calculated once per each row, based on the other data values in that row. For each row calculation, a formula value is returned for that row, which populate a new column of data. You can use these columns just like any others – format the data, add to a visualization, or group based on formula columns. They are treated the same as data columns.

To add a formula column to an ExpressView, open the MainLeftPaneDataFieldsSelected.png Data Pane  then click + Add Formula at the top of the pane. A blank column will be added to the ExpressView, and the Formula Builder will open.

In the right pane, the Formula section of the Selected Cell SelectedCellMenu.png page shows the available built-in functions and parameters. Hover over a function to see its description and an example of how to use it. To add a function or parameter to the formula, drag it from the Formula page to the Formula Builder window, type its name into the Formula Builder, or double-click the name of the function while the formula editor dialog is open. You can use the Search field in the to filter the functions by name.

formulaeditor.png
Formula editor dialog

To add a data field to the formula, either:

  • drag it from the Data Pane to the Formula Builder window
  • type its name into the Formula Builder
  • double-click the field name while the Formula Builder is open

Note

Double-clicking the field names will place the fields wherever the cursor is in the formula editor at that time. Double-clicking enabled in v2018.2 and later.

Tip

To use a data field, function, or parameter as a function argument, drag it to the argument placeholder until the placeholder turns blue. Or click the placeholder and type the name of the desired argument.

screen.expressview_drag_field_to_formula.png
Dragging a field to a function argument

Typing in the Formula Builder shows a list of functions, parameters, and data fields that match the text. Click on an item, or use the up and down arrow keys, to highlight an item and see its description. To add the selected item to the formula, press the Enter key.

A special type of parameter called a dropdown parameter can be created by the system administrator. These parameters have two values: the Value, used by the server for processing and the Display Value that appears in cells and is used in formulas. These distinct values can be accessed with @ParameterName.Value@ and @Parameter.DisplayValue@ respectively. For more information, consult with the system administrator.

When you are finished, click the Apply Changes custom.FormulaCheckmark.png icon at the top of the of the Formula Builder to save the formula.

To edit an existing formula column, click Selected Cell SelectedCellMenu.png, open the Formula tab, then click the column to reopen the Formula Builder.

See Formulas for more details on building formulas.

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Table of Contents