Server Calculations

Calculations

Syntax
General syntax rules for calculations, and how the functions work.

E
Entity
Log10E
Log2E
Null
Pi
SystemTime
True
False

Operators
Operators available for use in calculations, and how they are used.

Functions List

Cast

Boolean
DateTime
Decimal
Duration
Format
Integer
MakeDateTime
NumberToString
ParseDate
String

Conditional Logic
If
SingleValueIf
Select
Switch
SingleValueSwitch
TableLookup

Confidence Functions
Confidence
ConfidenceCutoff

Data Dictionary

DDAverage
DDCount
DDGet
DDGetAttributes
DDGetEntities
DDGetParent
DDHasTemplate
DDMax
DDMin
DDStdDev
DDSum

Date-Based Functions
Calendar Periods
Months
Production Periods

Digital State
NumberToState
StateToNumber

Error Handling

CatchError
CatchNull
RemoveNull
ReplaceNull
RemoveError
ReplaceError
ReplaceValues
CatchLowConfidence
CatchErrorOrNoSamples
CatchNoSamples

Mathematics
Simple Math Expressions
Averages
Minimums & Maximums
Small & Large
Count
Other Math

Shift
ShiftEnd
ShiftNumber
ShiftStart

Time

Second
Minute
Hour
Day
Weekday
Month
Year
AlterTimestamp
Time
TimeOf
RawTimeOf
TimeOfDay

Time Interval
TimeEq
TimeGe
TimeGt
TimeLe
TimeLt
TimeNe

Ungrouped

Caller
Concat
Current
Eval
EvalExp
Initial
SampleFilter
Sampling
ValueAt_Sampled

Comments are closed