Viewing Formula Description

When a cell is selected, which value is calculated using the configured algorithm executed on change, the formula string displays the calculated formula. If the cell value is obtained after calculation of several algorithms with several calculation blocks or aggregation blocks, the formula string displays information about the last calculated algorithm and the last block. If the formula contains the operand displayed in data entry form table areas, it is displayed as address of the cell, to whch the formula refers. If the formula contains the operand that is not displayed in data entry form table areas, it is displayed as a value. Operands are used in the form only if they are located on loaded data entry form sheets.

To view details about the calculation formula, use the Formula Description dialog box:

Open the dialog box

The dialog box contains the following information:

• Cell formulas list. The list of algorithms with calculation blocks. If a cell has several algorithms with calculation blocks or aggregation blocks, the last algorithm used for calculating the final cell value is displayed. This algorithm is the first in the list. Below are displayed all algorithms with control blocks in the order of their application. The list displays algorithm name, block name, formula name, calculation algorithm type, and the obtained value.

• The <Formula name> formula. Calculation formula of value in the cell, it is set as: <Source name>[<Dimension element name>]. If dimension element matches in all formula operands, it is not displayed in the formula.

• Values. Formula with substituted values with sequence numbers.

• Detailed Information About Formula Elements. List of values containing the following information:

• Sequence Number. Sequence number of the value matching the number from the value formula.

• Value.

• Data Entry Form Name. Name of the data entry form linked to the element calculation. Double-clicking the data entry form name or selecting the Open Form context menu item opens the form bound to algorithm.

• Coordinate. Source name and selection by all its dimensions.

If the value is selected in the Formula area, the following is automatically selected: the string with details about this element in the Detailed Information about Formula Elements area and the value in the Value area. If the string with details is selected in the Detailed Information About Formula Elements area, the appropriate value is automatically selected in the Formula area. If the value is selected in the value area, the following is automatically selected: the appropriate value in the Formula area and the string with detailed information about this element in the Detailed Information about Formula Elements area.

To finish viewing formula description, click the Close button or press .

After finishing to view details about the values obtained after executing the specified calculation practice, go to the step if it is required to:

• Add new records.

• Use interactive controls to manage selection.

• Set up display type.

• Sort and filter.

• Find and replace.

• Export data entry form.

• Preview and print data entry form.

See also:

Working with Ready Data Entry Form