# 数学函数

本部分介绍以下数学函数：

| 函数 | 描述 |
| --- | --- |
| [ABS](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/abs.htm) | 计算数值的绝对值 |
| [CBRT](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/cbrt.htm) | 计算数字的立方根 |
| [CEIL](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/ceil.htm) | 将数字向上舍入到最接近的整数 |
| [CEILING](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/ceiling.htm) | 将数字向上舍入到最接近的整数 |
| [度](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/degrees.htm) | 将指定的弧度转换为度 |
| [EXP](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/exp.htm) | 计算欧拉数指定次幂的值 |
| [FLOOR](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/floor.htm) | 将数字向下舍入到最接近的整数 |
| [GET_SHARD_NUMBER](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/get_shard_number.htm) | 返回输出/查找表的分片编号 |
| [LN](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/ln.htm) | 返回一个数的自然对数 |
| [LOG](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/log.htm) | 返回给定底数下 x 的对数 |
| [LOG2](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/log2.htm) | 返回 x 的以 2 为底的对数 |
| [LOG10](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/log10.htm) | 返回 x 的以 10 为底的对数 |
| [MOD](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/mod.htm) | 返回一个数除以另一个数的模（余数） |
| [MODULO](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/modulo.htm) | 返回第一个数除以第二个数的余数 |
| [POW](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/pow.htm) | 将一个数提高到另一个数的幂 |
| [幂](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/power.htm) | 将一个数提高到另一个数的幂 |
| [弧度](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/radians.htm) | 将以度为单位的角度转换为弧度 |
| [RAND](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/rand.htm) | 返回一个范围为 0.0 &lt;= x &lt; 1.0 的伪随机值 |
| [RANDOM](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/random.htm) | 返回一个范围为 0.0 &lt;= x &lt; 1.0 的伪随机值 |
| [倒数](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/reciprocal.htm) | 返回值的倒数 (¹/ₓ) |
| [ROUND](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/round.htm) | 将数字四舍五入到最接近的整数或指定的位数 |
| [SIGN](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/sign.htm) | 返回数字的符号函数 |
| [SORT_VALUES](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/sort_values.htm) | 按数值顺序返回已排序的值 |
| [SQRT](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/sqrt.htm) | 计算数字的平方根 |
| [TRUNCATE](https://help.qlik.com/zh-CN/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/truncate.htm) | 返回一个截断为整数或指定小数位数的数字 |