	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.

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.