SUB(list of values, comma separated): Works from left to right i.e. (((A -B)-C)-D) sub(historian/18FT3104:X.VALUE,10,10)
MUL(list of values, comma separated): mul(historian/18XSV2209:BCL,4)
DIV(list of values, comma separated): Works from left to right i.e. (((A/B)/C)/D) div(historian/18FT3104:X.VALUE,10,10)
MAX(list of values) - the max of two or more series at a point in time e.g. MAX(siggen/sin4@300,2)
MEDIAN(list of values) - returns the median across all tags in the list at a point in time
MEAN(list of values) - returns the mean across all tags in the list at a point in time
STDDEV(list of values) - returns the standard deviation across all tags in the list at a point in time
VARIANCE(list of values) - returns the variance across all tags in the list at a point in time
SQRT(x) - the Square root of each point in a series
LN(x) - the natural Log of each point in a
EXP(x)
LOG(x,y) -- log x base y
POW(x,y) -- x ^ y
THRESHOLD(a,b,c,d) - If a is above b then c else d - e.g. THRESHOLD(historian/80SE1417A:Z.X.VALUE,3000,1,0)
IFEQUALS(a,b,c,d) - If a = b then c, else d - e.g. IFEQUALS(historian/18_B1_FlowStatus,"flowing",1,0)
UNITCONVERT(source tag, output units) - this will only work on tags with properly configured units
SLIDINGAGG(source tag, function, time window) - e.g. (historian/4D-PI130102.AI,AVG,1h) - Functions = AVG, MIN, MAX, STDDEV, VAR, SUM, COUNT, NUMGOOD, NUMBAD, time window = 1d, 1h etc.
TOTALISE(basetag,windowsize,offset,rateunit) - e.g. TOTALISE(historian/18FT1204:X.VALUE,1d,0,1h) OR
TOTALISE(basetag, windowsize, startdate, rateunit) e.g. TOTALISE(pi/18FT1204:X.VALUE,365d,2016-01-01,1d)
UNITCONVERT(source tag, output units) - this will only work on tags with properly configured units