Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenGround | gINT | Keynetix
  • 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
    • Stephen Evason Created by Bentley Colleague Stephen Evason
    • When: Tue, May 31 2022 8:12 AM
    • Stephen Evason Last revision by Bentley Colleague Stephen Evason
    • When: Fri, Mar 3 2023 11:16 AM
    • Revisions: 4
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies