Type conversion functions in Tableau - Cell-by-Cell Formula Trace

Sample Data

Sample data with text strings representing different data types: integer, decimal, boolean, date, and text.

Cell	Value
A1	123
A2	45.67
A3	TRUE
A4	2024-06-01
A5	Hello

Formula Trace

INT([A2])

Step 1: Value in A2 is '45.67' (string)

Step 2: INT('45.67')

Cell Reference Map

   A   
1 123  
2 45.67
3 TRUE 
4 2024-06-01
5 Hello

The formula references cell A2 which contains the string '45.67'.

Result

   A    B
1 123   
2 45.67 45
3 TRUE   
4 2024-06-01
5 Hello  

The result of INT([A2]) is 45, shown in cell B2 next to the original value.

Sheet Trace Quiz - 3 Questions

What does INT('45.67') return in Tableau?

A 46

B 45

C 45.67

D Error

Key Result

INT(string_number) converts a string representing a number to an integer by truncating decimals.