Calculations

Summary

When a test is calculated, it is a transformation of other analyses within a sample. The language is flexible, and new features are being added all the time.

How it works

Test names used in a calculation must be enclosed in brackets [ ]. For example:

[Example_Test_Name]

All arithmetic expressions are supported. Spaces are suggested for readability but not required.

[Example_Test_Name] + 2 / ( [Another_Test] + [Yet_Another_Test] )

There is a built-in AVERAGE function that will simply disregard missing values.

Average([Test_1], [Test_2], [Test_3])

Conditionals (IF)

IF(Conditional_Expression, Value_If_TRUE, Value_If_FALSE)

Control Sample Analyses

When a sample type has a control type, it is possible to pull analyses values from a control sample into another sample for calculation. The test name must be in curly brackets { } and at least one control sample must be associated. When multiple control samples are associated, the result will be an average of all the given analyses. An example would be comparing a test to it's standard as a percentage:

[Example_Test] / {Example_Test_Standard}