Skip to main content

Number Functions (Locked)

Row-level number functions. Signatures cite help.tableau.com. All available in Desktop 2020.1+ unless noted.

Basic Arithmetic​

FunctionSignatureReturnNotes
ABSABS(number)NumberAbsolute value.
CEILINGCEILING(number)IntegerRound up to nearest integer.
FLOORFLOOR(number)IntegerRound down.
ROUNDROUND(number, [decimals])NumberOptional decimals arg; default 0.
SIGNSIGN(number)IntegerReturns -1, 0, or 1.
SQUARESQUARE(number)NumberSquares the input.
SQRTSQRT(number)NumberSquare root. NULL if negative.
POWERPOWER(number, power)NumberBase to the power.
EXPEXP(number)Numbere^x.
LNLN(number)NumberNatural log. NULL if ≤ 0.
LOGLOG(number, [base])NumberLog base 10 default; optional base arg.

Trig​

FunctionSignatureReturn
SINSIN(number)Number
COSCOS(number)Number
TANTAN(number)Number
ASINASIN(number)Number
ACOSACOS(number)Number
ATANATAN(number)Number
ATAN2ATAN2(y, x)Number
DEGREESDEGREES(radians)Number
RADIANSRADIANS(degrees)Number
PIPI()Number

Divisibility​

FunctionSignatureReturnNotes
DIVDIV(integer, integer)IntegerInteger division.
MAXMAX(a, b)NumberMax of two values (row-level; distinct from aggregate MAX).
MINMIN(a, b)NumberMin of two values (row-level).

Advanced​

FunctionSignatureReturnNotes
ZNZN(expression)NumberReturns 0 if NULL, else the value. Critical for R-NULL-01.
MODEL_QUANTILEMODEL_QUANTILE(quantile, target, predictors)Number2020.3+.
MODEL_PERCENTILEMODEL_PERCENTILE(target, predictors)Number2020.3+.

Common Anti-Patterns​

  • SUM([Sales]) / SUM([Rows]) where [Rows] is a raw field. Should be SUM([Sales]) / SUM(1) for a count, or better use AVG([Sales]).
  • Bare arithmetic on nullable fields without ZN wrapping. Should be ZN([Field A]) + ZN([Field B]) if NULLs should be treated as 0.
  • POWER(x, 0.5) when SQRT(x) reads more clearly.

Version Notes​

All functions listed available Desktop 2020.1+ except MODEL_QUANTILE and MODEL_PERCENTILE (2020.3+).