Date and Time functions
Year, Quarter, Month, Week, WeekOfMonth, Day, DayOfMonth, DayOfWeek, DayOfYear, Hour, Minute, Second
Conversion functions
SN
Math functions
Abs, ACos, ASin, ATan, ATan2, Ceil, Cos, Cosh, Exp, Floor, Ln, Log, Power, Sin, Sinh, Sqrt, Tan, Tanh
Operators
+, -, *, /, %, Mod
Statistical functions
Sum, Avg, Min, Max, Count, UniqueCount, Median, Variance, Var_Pop, Var_Samp, StdDev, StdDev_Pop, StdDev_Samp, Corr, CoVar_Pop, CoVar_Samp, Regr_AvgX, Regr_AvgY, Regr_Count, Regr_Intercept, Regr_R2, Regr_Slope, Regr_SXX, Regr_SXY, Regr_SYY
Text functions
Length, Lower, LTrim, RTrim, Soundex, Trim, Upper
Binning
Binning is supported.
See also: