PE functions by type

Abs

Absolute value

Asin

Arc sine

Acos

Arc cosine

Atn

Arc tangent

Atn2

Arc tangent (two arguments)

Cos

Cosine

Cosh

Hyperbolic cosine

Exp

Exponential

Float

Conversion of string to number

Frac

Fractional part of number

Int

Integer part of number

Log

Natural logarithm

Log10

Common logarithm

Poly

Evaluate polynomial

Round

Round to nearest unit

Sgn

Numerical sign

Sin

Sine

Sinh

Hyperbolic sine

Sqr

Square root

Tanh

Hyperbolic tangent

Tan

Tangent

Trunc

Truncate to next smaller unit

Avg

Average

Max

Maximum

Median

Median selector

Min

Minimum

PStDev

Population standard deviation

SStDev

Sample standard deviation

Total

Sum

BadVal

See if a value is bad (not a number or time)

Curve

Get value of a curve

DigState

Get digital state from a string

IsDST

Test whether a time is in local daylight saving time period

IsSet

Test if a PI value is annotated, substituted, or questionable

StateNo

The code number of a digital state

TagBad

See if a point has an abnormal state

NextEvent

Time of a point's next archive event

NextVal

Point's next value after a time

PrevEvent

Time of a point's previous archive event

PrevVal

Point's previous value before a time

TagVal

Point's value at a time

FindEq

Timestamp when point = value

FindGE

Timestamp when point >= value

FindGT

Timestamp when point > value

FindLE

Timestamp when point <= value

FindLT

Timestamp when point < value

FindNE

Timestamp when point != value

TimeEq

Total period when point = value

TimeGE

Total period when point >= value

TimeGT

Total period when point > value

TimeLE

Total period when point <= value

TimeLT

Total period when point < value

TimeNE

Total period when point != value

EventCount

Number of archive events

PctGood

Percent of good time in a period

Range

Range of minimum to maximum value

StDev

Time-weighted standard deviation

TagAvg

Time-weighted average

TagMean

Event-weighted average

TagMax

Maximum value in a period

TagMin

Minimum value in a period

TagTot

Time integral over a period

Bod

Timestamp for beginning of the day for given time

Bom

Timestamp for beginning of the month for given time

Bonm

Timestamp for first of the next month for given time

Day

Day of the month from a time

DaySec

Seconds since midnight from a time

Hour

Hour from a time

Minute

Minute from a time

Month

Month from a time

Noon

Timestamp for local noon of day of a time

ParseTime

Convert character string to time

Second

Second from a time

Weekday

Day of the week from a time

Year

Year from a time

Yearday

Day of the year from a time

Arma

Dynamic response from Auto Regressive Moving Average model

Delay

Introduce time delay

MedianFilt

Select the median value of time series

Impulse

Dynamic response characterized by impulse response shape

AlmAckStat

Alarm acknowledgment status code

AlmCondition

Condition code number for Alarm State

AlmCondText

Alarm condition as text

AlmPriority

Alarm priority number

Ascii

ASCII character code for a character

Char

String for ASCII character code(s)

Compare

Wild comparison of two strings

DigText

Text for a digital state

Format

Formatting of a numerical number

InStr

Instance of a sub-string

LCase

Conversion of all characters to lower case

Len

Length of a string

Left

First characters in a string

LTrim

Removal of blanks on the left side of a string

Mid

Extraction of a sub-string from a string

Right

Last characters in a string

RTrim

Removal of blanks on the right side of a string

Trim

Removal of blanks on both sides of a string

UCase

Conversion of all characters to upper case

Concat

Concatenate two or more strings

String

String representing any PI value

Text

Concatenation of strings for a series of PI value arguments