Search

Search Scripts

Scripting Reference Guides

Rick W

Tableau SQL Mathematical Functions

Mathematical Functions within Tableau.

Tableau SQL Mathematical Functions
Mathematical Functions within Tableau.
A. ABS:
AbsoluteValue = ABS(-10)

This example returns the absolute value of -10, resulting in 10.

B. SQRT:
SquareRoot = SQRT(25)

This example calculates the square root of 25, resulting in 5.

C. POW:
PowerResult = POW(2, 3)

This example raises 2 to the power of 3, resulting in 8.

D. LN:
NaturalLog = LN(10)

This example calculates the natural logarithm of 10, resulting in approximately 2.3026.

E. ROUND:
RoundedValue = ROUND(3.14159, 2)

This example rounds the number 3.14159 to 2 decimal places, resulting in 3.14.

Previous Article Tableau Date and Time Functions
Next Article Tableau SQL Text Functions
Print
223