Databricks

The tables listed below describe the Strategy function support for Databricks databases:

Function type	Functions that can be evaluated on the database
Basic functions	Add Average Avg Count First GeoMean Greatest Last Least Max Median Min Multiply Product Stdev StdevP Sum Union Var VarP
Date and time functions	AddDays AddMonths ConvertTimeZone CurrentDate CurrentDateTime CurrentTime Date DayOfMonth DayOfWeek DayOfYear DaysBetween FiscalMonth Fiscal Quarter FiscalYear Hour HourStartDateTime Millisecond Minute MinuteStartDateTime Month MonthEndDate MonthsBetween MonthStartDate Quarter QuarterStartDate Second ToDateTime Week WeekStartDate Year YearEndDate YearStartDate
Internal functions	Banding BandingC Case CaseV
Null and Zero functions	IsNotNull IsNull NullToEmpty NullToZero ZeroToNull
OLAP functions	FirstInRange Lag LastInRange Lead MovingAvg MovingCount MovingMax MovingMin MovingStdev MovingStdevP MovingSum OLAPAvg OLAPCount OLAPMax OLAPMin OLAPRank OLAPSum RunningAvg RunningCount RunningMax RunningMin RunningStdev RunningStdevP RunningSum
Rank and NTile functions	Rank
String functions	Char Concat ConcatBlank InitCap LastPosition LeftStr Length Lower LTrim Position RepeatStr RightStr RTrim SubStr TitleCap ToNumber ToString Trim Upper Version
Arithmetic operators
Comparison operators	BeginsWith Between EndsWith Not Like Not In
Comparison operators for rank
Logical operators	IF
Data mining functions
Financial functions
Mathematical functions	Abs Acos Acosh Asin Asinh Atan Atanh Atan2 Ceiling Cos Cosh Degrees Exp Floor Int (Integar) Int2 Ln Log Log10 Mod Power Quotient Radians RandBetween Round Round2 Sin Sinh Sqrt Tan Tanh Trunc
Statistical functions	Correlation Covariance Fisher Intercept InverseFisher Kurtosis Pearson RSquare Skew Slope Standardize SteYX