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:
| Code Block |
|---|
|
[Example_Test_Name] |
All arithmetic expressions are supported. Spaces are suggested for readability but not required.
| Code Block |
|---|
|
[Example_Test_Name] + 2 / ( [Another_Test] + [Yet_Another_Test] ) |
There is a built-in AVERAGE function that will simply disregard missing values.
| Code Block |
|---|
|
Average([Test_1], [Test_2], [Test_3]) |
Conditionals (IF)
| Code Block |
|---|
|
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:
| Code Block |
|---|
|
[Example_Test] / {Example_Test_Standard} |