Content Comparison

...

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 a 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}

...