Named Calculation Paths

You create named calculation paths that enable you to specify a sequential list of named calculation formats to scroll through. Each row in the list contains a sequence number and named calculation format. No limit is placed on the number of named calculation formats per named calculation path. Additionally, you can select any sequence for the named calculation formats.

You can leave a row blank, indicating a blank format, in the list. A blank format enables you to hide all configured columns in the program using configured grid columns. If you do not leave a blank format in the list, the system includes a blank format at the end of the list. To improve system performance, you should enter a blank format at the beginning of the list. If you enter a blank format at the beginning of the list, the system hides the configured grid columns when you open a program using configured grid columns. To enter a blank row in the sequence, you must enter a sequence number and leave the Named Calculation Format field blank.

You should give careful consideration when choosing the sequence and number of named calculation formats in the named calculation path. After you set up a named calculation path, review the sequence and number of named calculation formats to ensure that it meets requirements.

When creating a named calculation path, you can enter a sequence number or allow the system to enter the number based on the sequence of the rows in the list. As you create the list, you can change or delete the sequence number that you enter in the row. When you save a named calculation path, the system ensures that each row contains a number and that the sequence numbers are sequential. If necessary, the system will adjust the numbers in the list to ensure that the list remains sequential. If a row does not contain a sequence number, the system calculates the sequence and enters the correct sequence number for that row. The system also ensures that the sequence begins with the number 1.

Note: If you make changes when creating or modifying a named calculation path, you must click Save and Close, and then select the named calculation path on the Search for Named Calculation form to view the sequence that the system saves.

Consider the following examples:

  • You enter sequence numbers 1 through 6, and then delete sequence number 5. The system removes row 5. When you click Save and Close and then review the list, the system changes row 6 to row 5 and displays the list in the correct sequence.

  • You enter sequence numbers 1 through 6 and then reverse the row numbers 3 and 6. When you click Save and Close and then review the list, the system reorders the rows and displays them in the correct sequential order.

Additionally, when you save the named calculation path, the system alerts you to duplicate sequence numbers. If any rows exist with duplicate sequence numbers, the system highlights those rows. You must delete a duplicate row or provide a different sequence number for the highlighted rows. Otherwise, the system deletes the duplicate rows.

To save time as you set up named calculation paths, you can copy named calculation paths. You can change any values on the Add Named Calculation Paths form, but you must enter the value in the Named Calculation Path Name field.