ACE Analytics Creating Formula Columns

Click the Formula tab to use the feature that allows you to add calculated columns to the data.

New columns are added at the right side of the table but can be relocated by dragging them. Here's how to use this feature:

1. Help constructing a formula is available via the Formula Help button.
2. Enter the Name for the column that will be added to the table.
3. Insert column names into the Formula box by selecting them here and clicking Insert.
4. Enter the formula by typing it in here. Column names should be enclosed within square brackets [ ] and typical math operator symbols, such as + - * / should be used. You can always edit or delete anything in this space.
5. Specify the Data Type for the new column.
6. Specify a Display Format. Formatting options include numeric and date formats. Click Add to create the new column and refresh the table.
7. As formula columns are created, they're added to the Formula Columns list. Use the adjacent Replace and Remove buttons to manage the list. Columns that have been added are now included in the list of available columns (3) for use in other formulas.

Your application developer will have to advise you concerning which function set is valid in the Formula box. These can vary depending on the way in which data is retrieved from the data source. In one case, JavaScript-style functions can be used, but in another case only functions supported by the database server itself can be used. The help shown when you click the Formula Help button will provide useful information, based on the data source.

When done, click the Formula tab to hide the panel.