Common functions

You can use any of the Visual Basic functions. For example:

• Mathematical: Abs, Log, Log10, Exp, Round, Truncate

• String manipulations: Str, Cstr, Trim, Len, etc

• Program flow: If, Choose

Aggregate

The most common aggregators have been adapted so that you can write the formulas with a simplified syntax.

• Aggregators using the syntax: AggregatorName("FieldName or CCName", object list)

  Example: Sum("Peak_Area",CurrentSignal.AllPeaks) returns the sum of the area of the peaks of the current signal.

  • Average

  • CountDistinct

  • Max

  • Min

  • RelStdDev

  • RelStdDevP

  • StdDev

  • StdDevP

  • Sum

• Aggregators using the syntax: AggregatorName(List of Parameters)

  Example: Count(CurrentSignal.AllPeaks) returns the number of peaks in the current signal.

  • Count

All Microsoft Visual Basic functions can also be used with their VB syntax. For example, CurrentSignal.AllPeaks.First() returns the first peak of the current signal.

See Also

• Dictionary of expressions and enumerations