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])

...

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:

[Example_Test] / {Example_Test_Standard}

...