InfoGo - 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:
- Help constructing a formula is available via the Formula Help button.
- Enter the Name for the column that will be added to the table.
- Insert column names, functions, and operators into the Formula box by selecting them here.
- And/or enter the formula by typing it into the Formula box. 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 and you can enter formulas that don't contain data columns.
- Specify the Data Type for the new column.
- Specify a Display Format. Formatting options include numeric and date formats. Click Add to create the new column and refresh the table.
- 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 formulae.
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. For example, in one scenario, JavaScript-style functions can be used, but in another 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.
To prevent creation of unmanageable tables, numeric type Formula columns are not available for use in a Crosstab Table as the Header Values Column or the Label Values Column.
When done, click the Formula tab or button to hide the panel.