In this Salesforce tutorial, we will **learn the ASIN() function** and how we can use it to **calculate the arc sine value of numerical data**. In addition, we will also focus on its **syntax** and **some practical examples**.

While employed in a Sales Organization that uses Salesforce as a customer relationship management tool to track their sales. I got a task to **calculate the performance** **of employee sales commission**.

Here, I found an **ASIN() function as a solution** that helped me to calculate the performance metrics. Now, let us discuss in detail, **how to use the ASIN() function** to calculate the performance value of a number **in Salesforce Lightning as well as Salesforce Classic**.

## What is ASIN() function in Salesforce

In Salesforce, we have multiple functions that are used to perform mathematical calculations and the **ASIN()** **function** is one of the mathematical functions. Here, the** ASIN()** stands for **“arc sine”**.

To determine the inverse sine of an angle or value, use the **ASIN() **function. It is primarily utilized in Salesforce when trigonometric calculations are required or a radian value is required.

Additionally, it should be noted that the** ASIN() function** only works on numeric data types like Decimal, Integer, or Double. It will result in an error if you use it with other data kinds like text, dates, or other non-numeric data types.

### Syntax and Usage of Salesforce ASIN() function

Below is the syntax for the **ASIN() function**:

`ASIN(number/field/formula)`

The value for which we want to find the inverse sine is the **number/field/formula** parameter’s value. The parameter’s value can be a field, a constant number, or a formula.

To further understand the concept and syntax of the ASIN() method, let’s look at an example.

Assume that we want to determine the inverse sine value of the numeric field value **“Employee Sales Commission”** and that we will do so by using the **ASIN()** function. The formula reads as follows:

`Performance Score = 100 * ASIN((Avg Satisfaction- 3) / 2) / (PI() / 2)`

With this, we have adequate knowledge of the **syntax**, **logic**, and **illustration of the ASIN() function**. Moving forward, let’s try to figure out how to compute the inverse sine value in Salesforce Lightning.

## Calculate the inverse sine value in Salesforce Lightning

Here, are the steps to calculate the inverse sine value in Salesforce Lightning:

**Step 1:** Log in to Salesforce Lightning mode first, then click the **“Gear Icon”** in the top right corner of the page. Click **“Setup”** from the dropdown menu to continue.

**Step 2:** Select **“Object Manager” **from the menu’s left side.

**Step 3:** Use the search bar to look for the object you want to use with the **ASIN()** method. Since I want to keep track of the product demand, in this example, I look for the **“Product”** object.

**Step 4:** Now, click the **“Product”** object, and the product Page will be displayed.

**Step 5:** Select **“Field and Relationship”** from the menu on the left-hand side of the page.

**Step 6:** Press the **“New”** button to add a new formula field where the **ASIN()** function can be used.

**Step 7:** It will forward to the **“Choose the field type”** page; select the **“Formula”** data type by selecting the radio button next to it.

**Step 8:** Press the **“Next”** button to proceed.

**Step 9:** After entering the **“Field Label”** for the formula, the unique **“Field Name”** will be filled in automatically. I typed **“Product Demand”** into the field label in this instance.

**Step 10:** Select the **“Data Type”** for the field where the inverse sine value will be calculated. A numeric data type, such as **“Number”,** **“Currency”,** etc., must be indicated for the data type.

Here, I choose **“Number”** as the formula return type and click the radio button to the right of it.

**Step 11:** At this step, click the **“Next”** button to proceed to the next step.

**Step 12:** Enter the formula to compute the inverse sine value using the **ASIN() **function in the advanced formula editor.

I want to calculate the inverse sine of the product demand, in this case, using the **ASIN() **function. The formula is as follows:

`ASIN(Avg_Rating__c / 5) + ASIN(Units_Sold__c / 1000)) * 100 / (2 * PI())`

- The
**“Product Demand”**is determined by the formula using the**Average Rating**and the number of**Units Sold**. - The
**ASIN function**is employed and before using the ASIN function, the**Average Rating**is divided by 5, and the number of**Units Sold**is divided by 1000. - Following that, the calculated numbers are combined, multiplied by 100, then divided by the constant 2 times PI.

**Step 13:** To verify the formula and make sure there are no mistakes, click the **“Check Syntax”** option.

**Step 14:** Alternatively, we may define the **“Description”** and **“Help text”** as well as **“Handle the empty field”** if we like.

**Step 15:** To continue, press the **“Next”** button.

**Step 16:** Select the appropriate **“Level Security”** option. I have selected **“Visible”** in this case because I want it to be visible to everyone. Next, select **“Next”** from the menu.

**Step 17:** Following that, choose the **“Page Layout”** that will best display our content.

**Step 18:** In order to save the formula field, click the **“Save”** button.

Once we’ve set up the formula field, we may use it. Let’s examine an illustration:

- Create a new product with the fields
**“Avg Rating”**and**“Unit Sold”**by opening the**Product**Tab. - Click on the
**Details**section after that, and the**Product Demand**field will display the**ASIN()**function’s output.

As a result, we now know **how to calculate the inverse sine value in Salesforce Lightning.** Now, we’ll look at how to calculate the inverse sine value in Salesforce Classic.

Read ATAN() Function in Salesforce | Calculate inverse tangent value in Salesforce

## Calculate the inverse sine value in Salesforce Classic

The steps to determine the inverse sine value in Salesforce Classic are as follows:

**Step 1:** Open your Salesforce Classic edition from Salesforce Lightning. Click on **Avtar** and then click **Switch to Salesforce Classic**.

**Step 2:** Next, select **Setup** from the menu.

**Step 3:** Next, go to the **Build** section by scrolling down. The object for whose field we want to use the **ASIN()** function should then be selected under **Customise**.

I choose the **“Orders”** object in this instance because I want to monitor the profit margin.

**Step 4: **To get the choice for the new field, click on the **“Orders”** dropdown and choose the **“Fields” **option.

**Step 5:** To add a new formula field, scroll down to **“Custom Fields & Relationships”** and select the **“New”** option.

**Step 6:** It will go to the **“Choose the field type”** page; select the **“Formula”** data type by selecting the radio button next to it.

**Step 7:** Press the **“Next”** button to move on to the next followed step.

**Step 8:** When you enter the **“Field Label”** for the formula, the unique **“Field Name”** will be automatically filled out. In this case, I typed **“Profit Score”** into the specified field.

**Step 9:** Choose the **“Data Type”** for the field where the inverse sine value will be calculated. A numeric data type, such as** “Number”,** **“Currency”, **etc., must be specified for the data type.

In this instance, I select **“Number”** as the formula return type by selecting the radio button next to it. The decimal place was adjusted to 2.

**Step 10:** At this step, select **“Next”** to move to the proceeding step 3.

**Step 11:** Go to the advanced formula editor and type the formula to compute the inverse sine value using the **ASIN() function**.

In this instance, I want to use the **ASIN() function** to determine the inverse sine value of product margin based on customer input. The formula is as follows:

`Satisfaction__c + 100 * ASIN(Profit_Margin__c / 100) / (PI() / 2)`

- The
**Product Score**is determined by a formula based on**Satisfaction**and**Profit Margin**. The**Satisfaction**score is added directly to the formula. - To normalize the value of the
**Profit Margin**, it is divided by 100 and then put through the**ASIN**function. The result is then divided by the constant value of**PI ()**divided by 2, and finally multiplied by 100.

**Step 12:** Select **“Check Syntax”** to review the formula and ensure there are no errors.

**Step 13:** If we’d like, we may specify the **“Description”** and **“Help text”** as well as **“Handle the empty field”**.

**Step 14:** To proceed, use the **“Next”** button.

**Step 15:** Choose the appropriate **“Level Security” **field. Because I want it to be visible to everyone, I have chosen **“Visible”** in this instance. Select **“Next”** to continue after that.

**Step 16:** Next, choose the suitable **“Page Layout” **for the area where we wish to display this field.

**Step 17: **In order to save the formula field, click the **“Save”** button.

Once we’ve established the formula field, we may use it. Let’s examine an illustration:

- Create a new order with the fields
**Satisfaction**and**Profit Margin**by opening the**Order**tab. - When we click
**Save**, we are taken to the**Detail page**, where the**Product Score**field displays the**ASIN() function’s**output.

As a result, we now know **how to calculate the inverse sine value in Salesforce Classic.**

## Conclusion

With this, we have concluded that the **Salesforce function ASIN()** is a great tool for working with numerical data. In addition, we have learned practical examples such as **calculating sales** **commission**, **handling inverse sine**, **profit margin**, etc.

Moreover, we have also understood the concept of the **ASIN() function** with its syntax and procedure of calculating the inverse sine value in Salesforce Lightning and Salesforce Classic.

You may also like to read the following articles:

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.