Here is a short but hopefully informative post detailing the different number calculated field functions available to you in Tableau. There are a variety of uses that will be explained and exemplified
Abs- gives the user the absolute value of an integer without its sign
Example: ABS(-56)= 56
Acos/Asin/ Atan/Atan2 Function– Gives the user the arc cos of a number
Example: acos(0.3)= 1.266
Ceiling – rounds a number up to the nearest integer
Example: CEILING (3.2)= 4
Floor: Rounds a number down to the nearest integer
Example: FLOOR(3.7)= 3
Cos/Cot – Gives the user the cos/cot when given as radians by the user.
Degrees – converts from radians into numbers
Examples: Degrees (1.57079633)= 90
Div: gives the user the whole number of a division sum
Example: Div(7, 2)= 3
Exp: gives user E returned to the number specified
Example: EXP(6)= e~6
Log: gives the user the Log function of a specified number
Example: Log(100)= 2
MAX: returns the maximum value of an expression
Example: MAX({Profits}) = 12 564
MIN: returns the minimum value of an expression
Example: Min([Profits]) = 4
Pi: Gives user the value of pie
Example: PI ()= 3.14…..
Power: gives the user the ability to raise the power of a number to the specified number
Example: POWER(2, 2)= 4
Radians: turns degrees into radians.
Example: RADIANS(90) = 1.57079633
ROUND: rounds a number to its nearest whole number
Example ROUND(3.34)= 3
Sign: gives the user the sign of a number in the form of 1 if above zero, 0 if zero, and -1 is negative value
Example: SIGN(-3)= -1 OR SIGN(2)= 1
Sin: gives user the sine of a given angle.
Example: SIN(4.5)= 0.078
SQRT: gives the square root of a specified number:
Hopefully these number functions are helpful to you when using Tableua, with a wide variety of uses available to the user!
Photo by Volkan Olmez on Unsplash