Trigonometric functions
statementsAnalytics Platform System (PDW)
SQL analytics endpoint in
Microsoft Fabric
Warehouse in Microsoft Fabric
The following scalar functions perform a calculation, usually based on input values that you
provide as arguments, and return a numeric value.
Functions in this category evaluate the magnitude or directional sign of a numeric input. Use
them in data validation, normalization, financial modeling, and any scenario where the
positivity, negativity, or absolute scale of a value needs to be interpreted or standardized.
Description
ABS
Returns the absolute (positive) value of the numeric expression.
SIGN
Returns +1, 0, or -1 depending on whether the expression is positive, zero, or negative.
These functions convert floating-point or high-precision values into integers or fixed-precision
representations. They support reporting, bucketing, currency formatting, threshold calculations,
and any operation where values must align with discrete numeric boundaries.
Description
CEILING
Returns smallest integer greater than or equal to the expression.
FLOOR
Returns largest integer less than or equal the expression.
ROUND
Rounds a numeric value to the specified precision and length.
Expand table
Expand table