> For clean Markdown of any page, append .md to the page URL. > For a complete documentation index, see https://help.sigmacomputing.com/docs/math-functions/llms.txt. > For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server. # Math functions > Browse Sigma math functions available in formulas and calculations. Math functions perform mathematical operations, including arithmetic, trigonometric, rounding, statistical, and logarithmic calculations. | Function | Description | | ------------------------------------ | ------------------------------------------------------------------------------------------- | | [Abs](/docs/abs) | Returns the absolute value of a number. | | [Acos](/docs/acos) | Returns the arccosine of an angle. | | [Asin](/docs/asin) | Returns the arcsine of an angle. | | [Atan](/docs/atan) | Returns the arctangent of an angle. | | [Atan2](/docs/atan2) | Returns the arctangent of a coordinate pair. | | [BinFixed](/docs/binfixed) | Calculates the bin of a value among the specified number of identically-sized bins. | | [BinRange](/docs/binrange) | Calculates the bin for a value using the specified lower bounds. | | [BitAnd](/docs/bitand) | Calculates the bitwise `AND` of two numbers. | | [BitOr](/docs/bitor) | Calculates the bitwise `OR` of two numbers. | | [Ceiling](/docs/ceiling) | Rounds the number up to the closest multiple of equal or greater value. | | [Cos](/docs/cos) | Returns the cosine of an angle. | | [Cot](/docs/cot) | Returns the cotangent of an angle. | | [Degrees](/docs/degrees) | Converts the angle measurement from radians to degrees. | | [DistanceGlobe](/docs/distanceglobe) | Calculates the distance between two points on the globe, in kilometers. | | [DistancePlane](/docs/distanceplane) | Calculates the distance between two points on a plane. | | [Div](/docs/div) | Returns the integer component of a division. | | [Exp](/docs/exp) | Returns the mathematical constant `e`, or `2.71828`. | | [Floor](/docs/floor) | Rounds the number down to the closest multiple of equal or lesser value. | | [Greatest](/docs/greatest) | Returns the largest value from a list. | | [Int](/docs/int) | Rounds the integer down to the largest integer of lesser or equal value. | | [IsEven](/docs/iseven) | Returns True if the integer part of a number is even. | | [IsOdd](/docs/isodd) | Returns True if the integer part of a number is odd. | | [Least](/docs/least) | Returns the smallest value from a list. | | [Ln](/docs/ln) | Calculates the natural logarithm of a number, `log_e(n)`. | | [Log](/docs/log) | Calculates the logarithm of a number. Defaults to `log_10(n)`. | | [Mod](/docs/mod) | Returns the remainder component of a division. | | [MRound](/docs/mround) | Rounds the number down to the closest multiple of the specified number. | | [Pi](/docs/pi) | Returns the mathematical constant `π`, or `3.14159...`. | | [Power](/docs/power) | Calculates the result of a number raised to the specified power. | | [Radians](/docs/radians) | Converts the angle measurement from degrees to radians. | | [Round](/docs/round) | Calculates the number to the specified number of digits. | | [RoundDown](/docs/rounddown) | Rounds a number down to the specified number of digits or decimal places. | | [RoundUp](/docs/roundup) | Rounds a number up to the specified number of digits or decimal places. | | [RowAvg](/docs/rowavg) | Calculates the average value of a list of numbers. | | [Sign](/docs/sign) | Calculates the sign of a number. Returns `-1` if negative, `1` if positive, or `0` if zero. | | [Sin](/docs/sin) | Calculates the sine of an angle. | | [Sqrt](/docs/sqrt) | Calculates the square root of a number. | | [Tan](/docs/tan) | Calculates the tangent of an angle. | | [Trunc](/docs/trunc) | Truncates a number to the specified number of digits or decimal places. | > Official documentation and guidance for using Sigma to build AI apps, dashboards, and agents on governed warehouse data. ## Docs - [Abs](https://help.sigmacomputing.com/docs/abs.md): Use the Sigma Abs function to return the absolute, non-negative value of a number. - [Acos](https://help.sigmacomputing.com/docs/acos.md): Use the Sigma Acos function to compute the arccosine of the given angle. - [Asin](https://help.sigmacomputing.com/docs/asin.md): Use the Sigma Asin function to compute the arcsine of the given angle. - [Atan](https://help.sigmacomputing.com/docs/atan.md): Use the Sigma Atan function to compute the arctangent of the given angle. - [Atan2](https://help.sigmacomputing.com/docs/atan2.md): Computes the arctangent of the given coordinates. - [BinFixed](https://help.sigmacomputing.com/docs/binfixed.md): Use the Sigma BinFixed function to compute the bin for a value among the specified number of identically sized bins within the given bounds. - [BinRange](https://help.sigmacomputing.com/docs/binrange.md): Assigns the input value to a bin based on the provided cutoffs. - [BitAnd](https://help.sigmacomputing.com/docs/bitand.md): Returns the bitwise AND of two numbers. - [BitOr](https://help.sigmacomputing.com/docs/bitor.md): Returns the bitwise OR of two numbers. - [Ceiling](https://help.sigmacomputing.com/docs/ceiling.md): Rounds the input number up to the closest multiple of equal or greater value. - [Cos](https://help.sigmacomputing.com/docs/cos.md): Computes the cosine of the given angle. - [Cot](https://help.sigmacomputing.com/docs/cot.md): Computes the cotangent of the given angle. - [Degrees](https://help.sigmacomputing.com/docs/degrees.md): Converts an angle in radians to degrees. - [DistanceGlobe](https://help.sigmacomputing.com/docs/distanceglobe.md): Calculates the distance between two points on the globe, in kilometers. - [DistancePlane](https://help.sigmacomputing.com/docs/distanceplane.md): Calculates the distance between two points on the plane. - [Div](https://help.sigmacomputing.com/docs/div.md): Use the Sigma Div function to return the integer component of a division operation. - [Exp](https://help.sigmacomputing.com/docs/exp.md): Returns the mathematical constant e, also known as Euler's number (2.7183…), raised to the given power. - [Floor](https://help.sigmacomputing.com/docs/floor.md): Use the Sigma Floor function to round the input number up to the closest multiple of equal or lesser value. - [Greatest](https://help.sigmacomputing.com/docs/greatest.md): Returns the greatest value from two or more values with matching data types. - [GreatestNonNull](https://help.sigmacomputing.com/docs/greatestnonnull.md): Returns the greatest value from two or more values with matching data types, ignoring Null values. - [Int](https://help.sigmacomputing.com/docs/int.md): Rounds the input number down to the largest integer of equal or lesser value. - [IsEven](https://help.sigmacomputing.com/docs/iseven.md): Use the Sigma IsEven function to return True if the integer part of a number is even and return False is it is odd. - [IsOdd](https://help.sigmacomputing.com/docs/isodd.md): Use the Sigma IsOdd function to return True if the integer part of a number is odd and return False is it is even. - [Least](https://help.sigmacomputing.com/docs/least.md): Returns the smallest value from two or more values with matching data types. - [LeastNonNull](https://help.sigmacomputing.com/docs/leastnonnull.md): Returns the smallest value from two or more values with matching data types, ignoring Null values. - [Ln](https://help.sigmacomputing.com/docs/ln.md): Compute the natural logarithm of a number. - [Log](https://help.sigmacomputing.com/docs/log.md): Compute the logarithm of a number, defaulting to base 10. - [Mod](https://help.sigmacomputing.com/docs/mod.md): The Mod (modulus) function computes the remainder of a division operation, dividing the first value by the second value. - [MRound](https://help.sigmacomputing.com/docs/mround.md): Rounds the input number to the closest multiple of the given factor. - [Pi](https://help.sigmacomputing.com/docs/pi.md): Returns the mathematical constant π = 3.14159… - [Power](https://help.sigmacomputing.com/docs/power.md): Raises a number to the specified power. - [Radians](https://help.sigmacomputing.com/docs/radians.md): Converts an angle in degrees to radians. - [Round](https://help.sigmacomputing.com/docs/round.md): Use the Sigma Round function to round a number to the specified number of digits. - [RoundDown](https://help.sigmacomputing.com/docs/rounddown.md): Use the Sigma RoundDown function to round a number down to the specified number of digits. - [RoundUp](https://help.sigmacomputing.com/docs/roundup.md): Use the Sigma RoundUp function to round a number up to the specified number of digits. - [RowAvg](https://help.sigmacomputing.com/docs/rowavg.md): Returns the average value of the input numbers. - [Sign](https://help.sigmacomputing.com/docs/sign.md): Returns the sign of a number: -1 if negative, 1 if positive, 0 if zero. - [Sin](https://help.sigmacomputing.com/docs/sin.md): Computes the sine of the given angle. - [Sqrt](https://help.sigmacomputing.com/docs/sqrt.md): Compute the positive square root of a positive number. - [Tan](https://help.sigmacomputing.com/docs/tan.md): Computes the tangent of the given angle. - [Trunc](https://help.sigmacomputing.com/docs/trunc.md): Truncates the input value to the specified number of digits or decimal places.