# Mathematical functions

This section describes the following mathematical functions:

| Function | Description |
| --- | --- |
| [ABS](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/abs.htm) | Computes the absolute value of a number |
| [CBRT](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/cbrt.htm) | Computes the cube root of a number |
| [CEIL](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/ceil.htm) | Rounds a number up to the nearest integer |
| [CEILING](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/ceiling.htm) | Rounds a number up to the nearest integer |
| [DEGREES](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/degrees.htm) | Converts the specified radians to degrees |
| [EXP](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/exp.htm) | Computes Euler’s number raised to a certain power |
| [FLOOR](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/floor.htm) | Rounds a number down to the nearest integer |
| [GET_SHARD_NUMBER](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/get_shard_number.htm) | Returns the shard number of the output/lookup table |
| [LN](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/ln.htm) | Returns the natural logarithm of a number |
| [LOG](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/log.htm) | Return the logarithm of x to the given base |
| [LOG2](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/log2.htm) | Returns the base 2 logarithm of x |
| [LOG10](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/log10.htm) | Returns the base 10 logarithm of x |
| [MOD](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/mod.htm) | Returns the modulus (remainder) of one number divided by another |
| [MODULO](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/modulo.htm) | Returns the remainder of the first number divided by the second |
| [POW](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/pow.htm) | Raises one number to the power of another |
| [POWER](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/power.htm) | Raises one number to the power of another |
| [RADIANS](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/radians.htm) | Converts an angle in degrees to radians |
| [RAND](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/rand.htm) | Returns a pseudo-random value in the range 0.0 <= x < 1.0 |
| [RANDOM](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/random.htm) | Returns a pseudo-random value in the range 0.0 <= x < 1.0 |
| [RECIPROCAL](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/reciprocal.htm) | Returns the reciprocal of the value (¹/ₓ) |
| [ROUND](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/round.htm) | Rounds a number to the nearest integer or to a specified number of decimal places |
| [SIGN](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/sign.htm) | Returns the signum function of a number |
| [SORT_VALUES](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/sort_values.htm) | Returns the values sorted in numerical order |
| [SQRT](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/sqrt.htm) | Computes the square root of a number |
| [TRUNCATE](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/truncate.htm) | Returns a number truncated to an integer or to a specified number of decimal places |