This article covers everything you need to know about Numeric Equation field settings.
This article covers the Numeric Equation settings, you can find more on Equations here.
Numeric equations have the ability to perform calculations on field values, numbers, and other mathematical functions, while also providing the flexibility to format the results in a variety of number formats with decimals, rounding, currency, and more.
When the "Equation Type" is set to "Numeric", the Equation field recognizes the equation as a "numeric equation" and understands the type of data it will be working with.
Moving down in the field settings, you will come across the "Results Format" settings. This is where you have the opportunity to specify how you want your equation results to be presented.
- Decimals: Specifies how large numbers will be separated, either by commas, decimals, or with no separation.
- Decimal Places: When displaying the results of the numeric equation, you can choose how many decimal places to include. It's important to note that this setting only affects how the numbers are displayed, not how they are stored in the database.
- If the stored number has more decimal places than what you specify, the displayed number will be rounded accordingly.
- Rounding: You have the option to round the number either up or down. By default, numbers that end in a digit below 6 will be rounded down, while numbers that end in a digit 6 or above will be rounded up.
- Thousands delimiter: To make large numbers easier to read, you can choose to separate them with commas. For instance, "80000" would be displayed as "80,000".
- Number Format: You have the freedom to format your number using currency symbols, percentages, or personalize the text that appears before and after the number.