Formula Helper


The Formula Helper dialog is useful for creating complex formulas. It has two available views, the Functions/Scalars view and the Columns view. When the Columns view is active, (shown in the next graphic ), you can select a library and enter a table name and then press the Refresh button to download a list of the columns. Double clicking a column places the column into the formula editor.

Selecting the Functions/Scalars tab changes the Formula Editor view to show the available scalar functions. From here, you can drop down the category for the function you desire and see a list of available skeletons. Selecting a skeleton will cause the skeleton text to be placed into the Formula Editor.

Once you have completed editing you r formula, you can highlight the formula and drag it to an editor, or you can highlight the formula, Copy it and Paste it to the appropriate editor.