Commission Formula Field with airSlate SignNow

Commission formula field

hi welcome back to the section regarding configuration in Salesforce comm so most of the time there is a need to create fields which aren't necessarily stored in the database but rather is computed on the fly based on other fields or related fields for that object for this section we'll be discussing how to create such fields so we are going to create formula fields formula fields gives Salesforce administrators the ability to create fields which contain spreadsheet like formulas within this video we will be discussing the following first we'll be creating simple formula fields next we're going to be creating advanced formula fields using the advanced formula editor and next we're going to discuss how to create default value formula for non formula field so for our example we'll be creating foreign oil fields in the account object one computing average revenue per location one would be creating the expected condition for a particular user next we'll be discussing how to specify a default value for a custom field in the accounts object so first off we'll be creating a formula field using the simple formula editor the simple formula editor allows us to create simple formulas from other field so to start off let's just go to the setup menu let's go to customize click on accounts and click on fields let's go down to the account custom fields in relationships section to create our new custom field let's select formula as the datatype for this field and click on next first let's enter the field label for our formula let's just enter average revenue per location let's retain the field name generated by cell force and select the return type for our formula since this is average revenue per location we're going to select number for the decimal places let's just leave it at 2 and click on next when creating our formula we can either choose to select the field selector to select which fields we want to include in the formula or we can type it in directly given that we know the actual field name so for this field average revenue per location we are deriving the value of this using the fields annal revenue / each location or the number of locations for that account so let's select that field selector and select on number of occasions this will merge the number of locations field for this particular formula let's click on check syntax to validate our formula given that we have formulated and validated our formula let's click on next to proceed with our creation let's select on visible on the header to make our field visible to all profiles let's click next add our field to our page layouts so let's select this appropriate page layouts we want the seal to be displayed in so let's uncheck add field and handpick our page layouts so let's select account sales an account layout as well as account marketing click on save to finalize their changes that's it we have created our average revenue per location field which is a simple formula that just created for the accounts object so next off we're going to discuss how to create formula fields using the advanced formula editor so to start off let's just go back and click new again select on formula quick next let's type in expected commission as our field label and let's in your field name select currency as a return type retain our decimal place number and click on next using the advanced formula we're just going to select advanced formula in the tab bar the advanced editor allows you to retrieve data from related records through lookups or master detailed relationships as well as compared a simple formula which allows you just to get the simple fields for our object account so to start off let's just select insert field so first off we want to select the department name for a count owner of this particular record so let's select account select account owner drill down to the next couple of fields and select Department and click insert to insert our field so aside from inserting fields we can use different pre-built functions available on the formula editor to manipulate the values from the fields or to compete static values alone so in this example we'll be using the department field for the owner to determine whether a commission can be made for the account so let's enter the formula yes let's check if the department owner is equal to sales let's select the average revenue per location field that we just created earlier we can insert let's multiply that Bar commissions calculation which is 10% 0.10 and let's select the else value for this one so this means that if the owner is not the department sales are going to enter zero as the value for this expected commission field let's just check syntax to validate our formula since we are our formula let's proceed to save this field so for the blank field handling let's just select treat blank fields as serials so that we don't have any null errors with the field and let's click on next let's select visible on the column header to make it visible to all our pals let's just uncheck add field and select it for account and the account sales page layouts let's click on save to finalize our changes so that's it we have just created another formula field but this time using the advanced formula field editor so finally we'll be discussing how to create default values for unknown formula fields so this default values are calculated at point of creation in case the field is empty so for our example we're adding a new custom field called managing division so for this new custom field which is a text field we'll be creating a default value formula for this field that will be derived from the current users division as the default value for the managing division for this field so let's just click on you the creator field let's select text click on next let's enter our names managing the vision select 2 5 5 a certain length retain our field name go down to our default value section click on show formula editor so for this field we're going to derive it from the current user so we'll select dollar sign user this is a global standard for deriving the current users information so select user so we're going to select the field where we're going to derive the division of the current user so select count efficient click on next to finalize our changes Khan visible to show it to all profiles click on next and then click on save to finalize our changes so that's it so just as a recap we have covered creating formula fields formula fields can calculate values dynamically while having the computed value transient in the database they are extremely powerful tool for administrators because of the flexibility it offers without requiring the use of custom database triggers so in this video we have discussed the following first we discuss the creation and simple formula fields next we discuss the creation of advanced formula fields using the advanced form field editor and then finally we created the default value formula for non formula fields as well so in the next video we'll discussing how to create lookups and master detail relationships