Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!

The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
Information
  • Author: Appian Corporation
  • Type: Plug-in (Function & Smart Service)
  • Support: This plug-in or utility is not supported by the author. The content is free to use with a licensed product, but it is made available as-is and Community supported.
  • Compatible Version(s): 22.1
  • First Released:
  • Last Updated:
  • Cost: Free
Resources
Share
Home » AppMarket » Big Numbers Functions

Big Numbers Functions

Overview

This plugin supports running simple mathematical functions such as sum, product, and quotient with numbers larger than Appian Integer and Decimal data types support.

Key Features & Functionality

Functions:

  • bigsum - Adds all given numbers to return their sum. Returns a String.
  • bigproduct - Returns the product of the specified numbers. Returns a String.
  • bigquotient - Returns the quotient when numerator is divided by the denominator. Returns a String.
  • biground - Rounds off the number to the specified number of decimals. Returns a String.
  • bigconvert - Returns each of the inputs multiplied by the conversion rate. Returns a List of String.
  • biggt - Returns boolean if the number1 is greater than number 2.
  • biglt - Returns boolean if the number1 is less than number 2.
  • bigtrunc - Truncates a decimal number to the specified number of places after the decimal point.
  • bigabs - Returns the absolute value(s) of the specified number(s).
  • bigmod - Returns the remainder of dividend when divided by the divisor.
  • bigtostring - Converts a decimal number to a string to be used in the Big Number Functions Plug-in.

  • bigpow - returns the power of a number by an exponent to the specified number of places after the decimal point.

Anonymous
Parents

  • FYI if you ever find yourself needed to add validation on an a!textField for whether the user input is a valid number, this function accomplishes that: 

    if(
    a!isnullorempty(ri!input),
    true,
    regexmatch("^-?\d+(\.\d+)?$", ri!input)
)

    We were having trouble figuring out how to prevent a save in case the user input a non-number into our field that was saving big numbers. 

Comment

  • FYI if you ever find yourself needed to add validation on an a!textField for whether the user input is a valid number, this function accomplishes that: 

    if(
    a!isnullorempty(ri!input),
    true,
    regexmatch("^-?\d+(\.\d+)?$", ri!input)
)

    We were having trouble figuring out how to prevent a save in case the user input a non-number into our field that was saving big numbers. 

Children
No Data
© 2026 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.