What are Floor and Ceiling functions in Tableau ?

Floor and Ceiling functions belongs to number functions in Tableau.

Ceiling: This function helps in rounding a decimal value to greater or equal value.

Floor:  This Function in tableau helps to round an integer to is Lesser values or equal value.



Sum of sales = 2,,297,200.8603


Floor of sales = 2,297,200.000

Ceiling Function :


Ceiling of sales= = 2,297,201.000


Leave a Reply

Your email address will not be published. Required fields are marked *