Truncate
Syntax
Truncate(Numeric_Expression)
Input Parameters
Numeric_Expression
A valid double or exact-precision numeric expression to truncate.
Return Value
Returns the integral part of the specified decimal or double-precision floating-point number.
note
Note: The TRUNCATE() function is not supported when connected to the SparkSQL data warehouse.
Examples
Truncate the Internet Sales Amount Local] Measure to the integral component.
Truncate([Measures].[Internet Sales Amount Local])