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:
| No Format |
|---|
|
[Example_Test_Name] |
All arithmetic expressions are supported. Spaces are suggested for readability but not required.
| No Format |
|---|
|
[Example_Test_Name] + 2 / ( [Another_Test] + [Yet_Another_Test] ) |
There is a built-in AVERAGE function that will simply disregard missing values.
| No Format |
|---|
|
Average([Test_1], [Test_2], [Test_3]) |
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 a control sample must be associated. An example would be comparing a test to it's standard as a percentage:
| No Format |
|---|
|
[Example_Test] / {Example_Test_Standard} |