Creating a Calculation Formula

To create a formula:

1. Open the Formula Editor dialog box.

Open the dialog box

2. Execute one of the operations:

• Click the Add Formula button on the formula panel.

• Select the Add Formula item in the context menu of folder or formula panel.

3. Enter formula name and press the ENTER key. By default, the added formula is named as Calculation formula.

After executing operations, the formula will be added to the end of the formulas list to the current folder. Next, select calculated element and calculation calendar frequency.

The following operations are available when working with a formula:

• Rename formula.

• Add a comment to formula.

• Group formulas.

• Copy formula to clipboard.

• Paste formula from clipboard.

Renaming Formula

To rename a formula:

1. Select the Rename item in the formula's context menu. The formula name will be opened for edit.

2. Enter a new formula name and press the ENTER key.

After executing the operations the formula will be renamed.

The formula can also be renamed in the Formula Properties dialog box.

Adding a Comment to Formula

To add a comment to formula:

1. Select the Properties item in the formula's context menu. The Formula Properties dialog box opens:

2. Set the parameters:

• Name. If required, change formula name.

• NOTE. Enter short description of formula purpose.

3. Click the Apply button.

After executing the operations a comment will be added to the formula.

Grouping Formulas

To group formulas using folders:

1. Add a folder:

• Click the Add Folder button on the formula panel.

• Select the Add Folder item in the context menu of the folder or formula panel.

After executing one of the operations the folder will be added to the end of the formulas list or to the current folder.

2. Enter folder name.

3. Repeat the steps to add a folder set.

4. Drag formulas to the folder or from the folder. The folder can contain formulas and other folders with formulas.

After executing the operations the formulas will be grouped in folders.

To delete the folder:

1. Select the folder.

2. Execute one of the operations:

• Click the Delete button on the formula panel.

• Select the Delete item in the folder's context menu.

After executing the operations the folder is deleted with all formulas and folders contained in it.

Copying Formula to Clipboard

To copy a formula to clipboard:

• Select the Copy item in the formula's context menu.

• Select the formula and press CTRL+C.

After executing one of the operations the formula will be copied to clipboard.

Pasting Formula from Clipboard

To paste formula from clipboard:

• Select the Paste item in the formula panel's context menu.

• Press CTRL+V.

After executing one of the operations the formula will be pasted from clipboard to the end of the formulas list.