In this Salesforce tutorial, we will learn various Salesforce Mathematical Functions.
As we all know, Salesforce is one of the most popular customer relationship management (CRM) platforms. And its main goal is to manage clients’ data and support sales and marketing activities.
So, to make these activities easy and time-saving, Salesforce provides us with multiple mathematical functions that can be used in formulas, workflows, and reports.
Moreover, these mathematical functions help Salesforce users to execute complex calculations, draw insightful conclusions from data, and develop custom formulas as per particular company needs.
Let’s discuss each of the functions in detail article with various real-life industrial-based scenarios.
| Salesforce Maths Formula Functions | Description |
|---|---|
| ABS | Returns the absolute value of a number, a number without its sign. |
| ACOS | Returns the arc cosine of the number in radians, if the given number is between -1 and 1. Otherwise NULL. |
| ASIN | Returns the arc sine of the number in radians, if the given number is between -1 and 1. Otherwise NULL. |
| ATAN | Returns the arc tangent of the number in radians. |
| ATAN2 | Returns the arc tangent of the quotient of y and x in radians. |
| CEILING | Rounds a number up to the nearest integer, away from zero if negative. |
| COS | Returns the cosine of the number, where the number given in radians. |
| DISTANCE | Returns the distance between two locations using the provided unit. |
| EXP | Returns e raised to the power of a given number. |
| FLOOR | Rounds a number down, towards zero to the nearest integer. |
| GEOLOCATION | Returns a location based on the provided latitude and longitude. |
| LN | Returns the natural logarithm of a number. |
| LOG | Returns the base 10 logarithm of n. |
| MAX | Returns the greatest of all the arguments. |
| MCEILING | Rounds a number up to the nearest integer, towards zero if negative. |
| MFLOOR | Rounds a number down to the nearest integer, away from zero if negative. |
| MIN | Returns the least of all the arguments. |
| MOD | Returns the remainder after a number is divided by a divisor. |
| PI | Returns pi. |
| ROUND | Rounds a number to a specified number of digits. |
| SIN | Returns the sine of the number, where the number given in radians. |
| SQRT | Returns the positive square root of a number. |
| TAN | Returns the tangent of the number, where the number given in radians. |
| TRUNC | Truncates a number to a specified number of digits. |
Conclusion
In conclusion, these Salesforce mathematical functions are strong tools that give Salesforce customers the ability to handle a variety of calculations and data analysis.
In addition, these functions offer a practical and effective ways to manage mathematical operations within Salesforce. We can use or need these mathematical Salesforce functions to aggregate data, compute numbers, or develop complex formulas.
I am Bijay Kumar, the founder of SalesforceFAQs.com. Having over 10 years of experience working in salesforce technologies for clients across the world (Canada, Australia, United States, United Kingdom, New Zealand, etc.). I am a certified salesforce administrator and expert with experience in developing salesforce applications and projects. My goal is to make it easy for people to learn and use salesforce technologies by providing simple and easy-to-understand solutions. Check out the complete profile on About us.