Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
themeConfluence
Average([Test_1], [Test_2], [Test_3])

Conditionals (IF)

Code Block
themeConfluence
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:

...