Bentley Communities
Site
Search
User
Site
Search
User
Product Communities
OpenGround | gINT | Keynetix
OpenGround Wiki
Mathematical Functions
Sign In
-
OpenGround Wiki
-
Applications
+
Admin Portal
+
Civil 3D Extension
+
Data Collector
+
Data Entry Module
+
Excel Extension
+
Launcher
+
OpenGround Professional
+
Portal Technical Preview
+
Power BI Connector
-
Template Studio
Template Studio Release Notes
+
Template Studio How Tos
+
Template Studio FAQ's
+
Template Studio Common Issues
-
Template Studio User Guide
+
Working with Templates
+
The Interface
Important Template Settings Information
+
Using Template Studio
+
Template Setup
+
Column Configuration
+
Depth Related Items
+
Designing Header and Footer Areas
+
Designing Tables
+
Filter Groups
+
Types of Template
-
Powerful Expressions
+
Expression Library
Adding Text to Fields
Building Your Own Expressions
Changing Display Decimal Places
Combining Columns
-
Different Types of Expressions
Excel Functions
Log Only Functions
Run Time Functions
Text Styling
Mathematical Functions
General Rules for Expressions
Nesting Functions
Referencing Columns in a Grid
+
Upload Portal
+
Web API and Task Service
+
Web Portal
+
Guides and Learning
OpenGround Supported Platforms
+
How To Contact Support
Component Center
Events
Training Guides
+
Developer Resources
Questions about this article, topic, or product? Click here.
Mathematical Functions
Mathematical Functions Function
Description
Example
Abs
Returns the absolute value of a specified number.
Abs(-1)
Acos
Returns the angle whose cosine is the specified number. Angle is returned in radians.
Acos(1)
Asin
Returns the angle whose sine is the specified number.
Angle is returned in radians.
Asin(0)
Atan
Returns the angle whose tangent is the specified number.
Angle is returned in radians.
Atan(0)
Function
Description
Example
Ceiling
Returns the smallest integer greater than or equal to the specified number.
Ceiling(1.5)
Cos
Returns the cosine of the specified angle. Angle must be in radians.
Cos(0)
Exp
Returns e raised to the specified power.
Exp(0)
Floor
Returns the largest integer less than or equal to the specified number.
Floor(1.5)
IEEERemainder
Returns the remainder resulting from the division of a specified number by another specified number.
IEEERemainder(3, 2)
Log
Returns the logarithm of a specified number.
Log(1, 10)
Log10
Returns the base 10 logarithm of a specified number.
Log10(1)
Max
Returns the larger of two specified numbers.
Max(1, 2)
Min
Returns the smaller of two numbers.
Min(1, 2)
Pow
Returns a specified number raised to the specified power.
Pow(3, 2)
Round
Rounds a value to the nearest integer or specified number of decimal places. The mid number behaviour can be changed by using EvaluateOption.RoundAwayFromZero during construction of the Expression object.
Round(3.222, 2)
Sign
Returns a value indicating the sign of a number.
Sign(-10)
Sin
Returns the sine of the specified angle.
Angle must be in radians.
Sin(0)
Sqrt
Returns the square root of a specified number.
Sqrt(4)
Tan
Returns the tangent of the specified angle.
Angle must be in radians.
Tan(0)
Truncate
Calculates the integral part of a number.
Truncate(1.7)
Share
History
More
Cancel
Created by
Stephen Evason
When:
Tue, May 31 2022 8:12 AM
Last revision by
Stephen Evason
When:
Fri, Mar 3 2023 11:16 AM
Revisions:
4
Comments:
0
Recommended
Related