Table of Contents

Numeric Equation Settings

Danielle Kellogg Updated by Danielle Kellogg

This article covers the numeric equation settings, you can find more on Equations here.

Numeric equations can run calculations on field values, numbers, and other mathematical functions and format results in various number formats with decimals, rounding, currency, etc.

Equation fields are considered “numeric equations” when the “Equation Type” is set to “Numeric”. This tells the equation field what type of data the equation will be using.

Further down in the field settings you will find the “Results Format” settings. Here you can define how your equation results will be formatted. 

  • Decimals: Defines how large numbers will be separated by commas, decimals, or nothing.
  • Decimal Places: The number of decimal places to include when displaying the numeric equation results. This doesn't affect how the numbers are stored in the database, only how they are displayed. If the stored number has more decimal places than this option, than the displayed number will be rounded.
  • Rounding: Whether the number should be rounded up or down. If using the default setting, numbers ending in a number below 6 will round down, and anything else rounds up.
  • Thousands delimiter: Whether commas will separate thousands in large numbers. For example, 80000 would display as 80,000.
  • Number Format: Options to format your number with currency letters or your own custom before and after text.

How did we do?

Text Formula Functions

Conditional Rules