Formulas

Select the checkbox to have the filter only display active formulas in the system. 

Select Refresh to refresh the page to view new results when filtering.

Enter the name of the formula in the field. This is a required field.

Select to display the Change Log pop-up to show all of the changes that have been made for that record.

• Certification Settings: Select to display the Certification Change Log Settings pop-up to view settings. Select Close to close the pop-up.
• Changes Made by: Select an option from the drop-down list to filter the table based on who made the changes. Select either All, Host, User, Patient, Orchard Superuser, or System from the drop-down list.
• Event: Select an option from the drop-down list to filter the table based on the type of event. Select either All, Create, Update, or Delete from the drop-down list.
• Start/End: Enter date/time values in the fields to specify the date/time range for the filter. Select Now to enter the current date/time, or select Clear to clear the fields.
• Type (Table Name) Search Text: Enter text in to the field to search for a specific instance.
• Print Selected: Select to print the selected Change Log records.
• Export Selected: Select to export the selected Change Log records.
• Delimiter drop-down list: Select either Comma, Double quotes and comma, Semicolon, Tab, or Vertical bar to specify a delimiter.
• Reset Filter: Select to reset the filter and begin filtering with new criteria.
• Refresh: Select to update the table with new filter criteria.
• Select: Select the checkbox to chose specific Change Log records to print, export, etc.
• OK: Select to close the Change Log pop-up.

Enter text into the field to search for a specific test. The table will automatically refresh with new results.

The table displays the formula ID in the column.

Select on the blue link in the Formula ID column to add the formula ID to the last place that the cursor was in the text area in the Formula field. Text values are also supported for results by entering the identifier in the format:

#<Formula Identifier>:TEXT#

By default, all tests in a formula must have results in order for the formula to be evaluated. However, tests can be made optional by surrounding the formula ID with { } or [ ] .

For example:

{#<Formula Identifier>#}

or

[#<Formula Identifier>#]

If the formula identifier is surrounded by { }, zero will be used as the value for the test result. If the formula identifier is surrounded by [ ], the empty result value of -999.99 will be used as the value for the test result. If the formula identifier contains the text :TEXT in order to use the text result, a blank value will be inserted for the test results in both cases.

Enter the formula values mentioned above in the Formula Value fields listed for F/M , Female , M/F , Male , and Unknown in the Name column.

Enter text in to the field to search for a specific race or species to be populated in the table. For example: African-American, Asian, Black, Cat, Dog, Caucasian, etc.

Enter the formula value for these in the Formula Value fields. Select either Human and Animal, Human Only, or Animal Only from the Classification drop-down list to specify the classification of the race/species. Select the Show active only checkbox to have the table only show active results.

Displays the formula as it currently exists.

After filling in values, select Calculate Result to run the formula with the current values.

If no issues occur while running the formula, the result of the formula will be displayed at the bottom of the pop-up. If an issue does occur while running the formula, the issue will be displayed in an alert to the user.

Potential issues that could keep a formula from evaluating include:

• Required formula identifiers not being filled in with a value
• Syntax errors in the formula itself (such as a misspelling of a command or identifier)
• Conditional formulas that evaluated to false without a false value specified
• The result of the formula being a text value when the formula is set to be saved as a numeric value
• Runtime error that occurred while evaluating the formula

When editing or adding a formula, a name, test to calculate results for, and formula must all be specified in order to save.

Additionally, circular formulas are not allowed to be entered. A circular formula is a formula that contains the formula identifier of the test that the formula is being evaluated for. This includes other formulas that affect the result of the formula as well. For example: if you have two formulas, and formula one calculates its result from the test calculated by formula two, and formula two calculates its result from the test calculated by formula one, then that is considered a circular formula because the two formulas would constantly update each other instead of evaluating to a specific result.

Formulas will be evaluated for the entire order rather than just the selected order choice. This means that it is possible for results on a different order choice on the order to be updated while modifying an order choice. It is also possible for an approved order choice on an order to have its results amended by formulas when a different order choice is updated. If this case occurs, then a comment will be added to the amended test result in order to state that formulas amended the result and how the result was changed. All formulas on the order will be evaluated when the user opens the Approve Results pop-up on the Work in Progress page. Formulas will be sorted so that any formulas which would affect the result of other formulas will be evaluated before the other formulas are evaluated. After that point, formulas will be evaluated when changes are made to the numeric or text result. Only formulas that are affected by the changed result will be reevaluated. If the user cancels on the Approve Results pop-up, then any changes made by formulas will be discarded.

Formulas will also run for instrument results received from a device engine. In this case, all formulas on the order will be evaluated when the instrument results are received.