## Tableau: Number Functions

by Nitesh Shrestha

In Tableau, we can use number functions to manipulate, transform, and analyze our numerical data as per our analysis.

Here are some of the common number functions used in Tableau.

 Function Syntax Description Example ABS ABS (number) Returns the absolute value of a given number. ABS (-20) = 20 SUM SUM (Number Field) Returns the sum of all values in the expression. Null values are ignored. SUM([Sales]) AVG SUM (number) Returns the average of all values in the expression. Null values are ignored. AVG([Sales]) MEDIAN MEDIAN(number) Returns the median of a single expression. Null values are ignored. MEDIAN([Sales]) MAX MAX(number) Returns the maximum value of the field (based on the filter and dimensions used in a visualization) and provides the highest value. If the [Profit] field contains values ranging from 6000 to 8000 MAX[Profit] = 8000 MIN MIN(number) Returns the minimum value of the field (based on the filter and dimensions used in a visualization) and provides the lowest value. If the [Profit] field contains values ranging from 6000 to 8000 MIN[Profit] = 6000 ZN ZN(number) Returns zero if null and the number if not null. ZN(Null) = 0 or ZN(10) = 10 CEILING CEILING(number) Rounds a number to the nearest integer of equal or greater value. CEILING(3.14) = 4 FLOOR FLOOR(number) Rounds a number to the nearest integer of equal or lesser value. FLOOR(3.14) = 3 DIV DIV(Integer1, Integer2) Returns an integer value after diving Integer1 with Integer2. DIV(13/3) = 4 POWER POWER(number, power) Raises a number to a specified power. POWER(5, 2) = 25 ROUND ROUND(number, decimal) Rounds numbers to a specified number of digits. The decimal argument specifies how many decimal points of precision to include in the result. If the decimal is omitted, the number is rounded to the nearest integer. ROUND(3.15, 1) = 3.1 ROUND(3.15) = 3 SIGN SIGN(number) Returns a sign of a number. SIGN([Profit]) The possible return values for each row is. -1 if the profit is negative, 0 if the profit is zero and 1 if the profit is positive. SQRT SQRT(number) Returns a square root of a number SQRT(25) = 5 SQUARE SQUARE(number) Returns the square of a number SQUARE(4) = 16 Nitesh Shrestha

Fri 29 Sep 2023

Wed 27 Sep 2023

Tue 26 Sep 2023