# 數學函數

本區段說明下列數學函數：

| 函數 | 描述 |
| --- | --- |
| [ABS](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/abs.htm) | 計算數字的絕對值 |
| [CBRT](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/cbrt.htm) | 計算數字的立方根 |
| [CEIL](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/ceil.htm) | 將數字向上捨入到最接近的整數 |
| [CEILING](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/ceiling.htm) | 將數字向上捨入到最接近的整數 |
| [DEGREES](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/degrees.htm) | 將指定的弧度轉換為度數 |
| [EXP](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/exp.htm) | 計算歐拉數的某個次方 |
| [FLOOR](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/floor.htm) | 將數字向下捨入到最接近的整數 |
| [GET_SHARD_NUMBER](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/get_shard_number.htm) | 傳回輸出/查閱資料表的碎片編號 |
| [LN](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/ln.htm) | 傳回數字的自然對數 |
| [LOG](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/log.htm) | 傳回 x 以指定底數為底的對數 |
| [LOG2](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/log2.htm) | 傳回 x 以 2 為底的對數 |
| [LOG10](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/log10.htm) | 傳回 x 以 10 為底的對數 |
| [MOD](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/mod.htm) | 傳回一個數字除以另一個數字的模數 (餘數) |
| [MODULO](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/modulo.htm) | 傳回第一個數字除以第二個數字的餘數 |
| [POW](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/pow.htm) | 將一個數字提高到另一個數字的冪次 |
| [乘冪](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/power.htm) | 將一個數字提高到另一個數字的冪次 |
| [RADIANS](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/radians.htm) | 將角度從度數轉換為弧度 |
| [RAND](https://help.qlik.com/zh-TW/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-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/random.htm) | 傳回一個範圍介於 0.0 &lt;= x &lt; 1.0 的偽隨機值 |
| [RECIPROCAL](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/reciprocal.htm) | 傳回值的倒數 (¹/ₓ) |
| [ROUND](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/round.htm) | 將數字四捨五入到最接近的整數或到指定的小數位數 |
| [SIGN](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/sign.htm) | 傳回數字的符號函數 |
| [SORT_VALUES](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/sort_values.htm) | 傳回依數值順序排序的值 |
| [SQRT](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/sqrt.htm) | 計算數字的平方根 |
| [截斷](https://help.qlik.com/zh-TW/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Lakehouse/TransformationFunctions/mathematical/truncate.htm) | 傳回截斷為整數或指定小數位數的數字 |