List of expression functions reference
- Last UpdatedJan 10, 2025
- 1 minute read
- PI System
- PI Server 2018
- PI Server
Expression functions available for use in expression and event frame generation analyses are listed alphabetically. These functions follow performance equation (PE) syntax.
Note: Expression functions (ArrayLength, FilterData, FirstValue, InterpolatedValues, LastValue, MapData, RecordedValues and RecordedValuesByCount) that enable you to retrieve and manage multiple values as an array may not work very well with attributes configured as PI point array data reference.
Related Links
- Abs
- Acos
- AND
- ArrayLength
- Ascii
- Asin
- Atn
- Atn2
- Avg
- BadVal
- Bod
- Bom
- Bonm
- Ceiling
- Char
- Compare
- Concat
- Contains
- Convert
- Cos
- Cosh
- Cot
- Coth
- Cov
- Csc
- Csch
- Curve
- Day
- DaySec
- DeltaValue
- DigState
- DigText
- E
- ELSE
- EventCount
- EventFrame
- Exit
- Exp
- FilterData
- FindEq
- FindGE
- FindGT
- FindLE
- FindLT
- FindNE
- FirstValue
- Float
- Floor
- Format
- Frac
- HasChanged
- HasValueChanged
- Hour
- IF
- IN
- InStr
- Int
- InterpolatedValues
- IsSet
- LastValue
- LCase
- Left
- Len
- LinRegr
- Log
- Log10
- Logbase
- LTrim
- MapData
- Max
- Median
- Mid
- Min
- Minute
- Mod
- Month
- NextEvent
- NextVal
- Noon
- NoOutput
- Normalrnd
- NOT
- NumOfChanges
- OR
- ParseTime
- PctGood
- Pi
- Poisson
- Poly
- Pow
- PrevEvent
- PrevVal
- PStDev
- Rand
- Range
- Rate
- RecordedValues
- RecordedValuesByCount
- Remainder
- Right
- Round
- Roundfrac
- RTrim
- Sec
- Sech
- Second
- SecSinceChange
- Sgn
- Sin
- Sinh
- Split
- Sqr
- StateNo
- SStDev
- StDev
- String
- TagAvg
- TagBad
- TagDesc
- TagEU
- TagExDesc
- TagMax
- TagMean
- TagMin
- TagName
- TagNum
- TagSource
- TagSpan
- TagTot
- TagType
- TagTypVal
- TagVal
- TagZero
- Tan
- Tanh
- Text
- THEN
- TimeEq
- TimeGE
- TimeGT
- TimeLE
- TimeLT
- TimeNE
- TimeStamp
- Total
- Trim
- Year
- Trunc
- UCase
- Weekday
- Yearday