We use Salesforce CRM to manage our sales business. We wanted to calculate and store the difference between the Target Sales and Actual Sales in a custom field. As a Salesforce Admin, I created a Formula Field on the opportunity object. In the formula, I used the ABS() function so that the result always shows … Read more >>>
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 … Read more >>>
Recently, I worked as a system administrator at a company that uses Salesforce to run its business efficiently. While working, I was assigned the task of calculating the number of leads required to meet the target. As a solution, I discovered that Salesforce gives us the “MCEILING” function that helps in calculating the round-off value … Read more >>>
When analysing sales performance in Tableau, I generally use the SUM() and AVG() functions to find the total and average values. But sometimes showing the average and sum is not sufficient for accuracy when the data includes values much higher or much lower than the rest. When the dataset has these outliers, we should prefer using the … Read more >>>
In Salesforce, the Service Agent is one type of AI Agent available in Agentforce. After creating and deploying it to a Salesforce experience (community) site, end users or customers can easily interact with the agent to raise requests or get support. To route the request from the site to the service AI agent, we create an Inbound … Read more >>>
In Salesforce, the Service Agent is one type of AI Agent available in Agentforce. After creating the service agent in Agentforce, we need to deploy it to a Salesforce experience (community) site so that end users or customers can easily interact with the agent to raise requests or get support. Now, whenever an end user … Read more >>>
Recently, I was hired by a New York-based company that uses Salesforce CRM to manage its operations. I was given a job at work that required me to determine the overall amount of funds raised for the campaign. As a solution, I discovered that Salesforce gives us the function named “MOD”, which helps in determining … Read more >>>
I recently joined a USA-based IT company that uses the powerful customer relationship management system “Salesforce” to deal with the business world. One day, I was assigned the task of calculating the maximum lead score across all leads. As a solution, I discovered that Salesforce gives us the function named “Max() Function”, which is used to calculate … Read more >>>
While working at a company that uses Salesforce CRM, I got a task from the client to predict viral trends based on user engagement analysis. As a solution, I discovered that the EXP() function determines viral trends based on user engagement analysis. In this tutorial, we will learn the EXP() function in Salesforce and how to use … Read more >>>
While analysing the Sample Superstore dataset, I wanted to filter data by multiple related fields. For example, selecting a Region should automatically filter by States, and those States should further filter by Cities. Initially, I applied filters independently, but it didn’t update the records based on each other’s selection. As a solution, I used Tableau’s … Read more >>>