ExpressView: Formula Columns (pre-v2021.1)
This topic applies to the ExpressView Designer in pre-v2021.1. For v2021.1+, refer to ExpressView: Introduction (v2021.1+)
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.
In the right pane, the Formula section of the Selected Cell 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.
- 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
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.
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
@Parameter.DisplayValue@ respectively. For more information, contact the system administrator.