Recently, I was working in the finance department of a multinational company that sells electronic gadgets.
To manage their sales data, they use Salesforce. One day, I was tasked with calculating the total revenue for each sales transaction and rounding it to the nearest whole amount.
As a solution, I discovered that this Salesforce tool provides us with the function named “ROUND”, which helps in rounding the nearest number to a number that we specify.
In this tutorial, we will learn about the Round() function in Salesforce. We will also study the syntax for this function, as well as numerous Salesforce examples from real-world organisations.
ROUND() Function in Salesforce
The ROUND() function in Salesforce is a built-in mathematical function used to perform calculations. In basic terms, the ROUND() function rounds a number to a specified number of digits.
In addition, the ROUND() function only supports numeric data types, such as Integers, Decimals, and Currency. However, if you attempt to use a text, date, or other non-numeric data type, an error will result.
The syntax of the ROUND() function is as follows:
ROUND(number,num_digits)Here, the number is the value whose rounded value we want to find, and num_digits is the number of digits to which the number is rounded. The value of the parameter number can be a field, a constant number, or a complex formula.
For a better understanding of how the ROUND function works, let’s look at an example.
As I mentioned above, I need to figure out the total revenue for each sales transaction and round it to the nearest whole amount. I will therefore utilise Salesforce’s ROUND() method for this. The formula is as follows:
ROUND(Total_Revenue__c, 0)With this, we learned the syntax of the ROUND() function and an example. We’ll now look at how to use the ROUND() function in Salesforce.
Use the ROUND() Function in Salesforce
The following are the steps to use the ROUND() function in Salesforce:
- Click the “Gear Icon” in the top right corner of the screen. Click “Setup“ in the dropdown menu to continue.
- After choosing the Setup option, the setup screen is displayed. The “Object Manager” is found in the Navigation Bar next to the Home tab. Click on it.
- After clicking it, the object manager page is displayed. We can see a lot of the objects here. To find the object we wish to apply the ROUND() function to, enter a search term in the search field.
- In this case, I search for the “Price Book” object because I need to round the price to the nearest value.
- To access the “Price Book” object page, click the Price Book item.