Some percentage then LESS a value from the screen

Some percentage then LESS a value from the screen

It is not common, but some Deduction rules need this use case:

First, Calculate Gross commission x  some %.   OR
First, Calculate Gross commission - 8% off the top THEN  x some %

so far, this is a normal calculation.

But what if, after that calculation is complete, there's a rule that need to then subtract some previously calculated value (like contribution to Charity or contribution to an Advertising bank)

In that case, do this formula:

The first calculation is in () to identify that this multiplication should be done first:

=( [Gross Commission]  * .92)

Then the next multiplication is times the % from the Agent profile

=( [Gross Commission] *0.92) * [Agent profile - Company  $ (%)])

Finally, a value from the screen is subtracted.  In formulas it is standard that multiplication happens before subtraction so in this case, the result of the part in () is multiplied time the Agent profile % - and then finally, the value from the screen [Ad bank list] is subtracted after all the multiplication is complete:

 =( [Gross Commission] *0.92) * [Agent profile - Company  $ (%)]) - [Charity]

To add this:

  1. Click Formulas
  2. Click Deduction rules
  3. Click Company $
  4. Click new button

From the popup window

Step 1: choose deduction type is automatically filled

  1. Click next button

Step 2: choose name and sort order

  1. Enter rule name
  2. Sort order sequence is 1
  3. Click next button

Step 3: apply this rule for only one side OR select ALL if this rule applies when Agent is on either side

  1. Choose All for side
  2. Click next button

Step 4: only apply this rule to agents where the commission plans or subplans meet these criteria

  1. Choose a commission plan that needs this rule from the dropdown, example for this
  2. Choose all to include all agent commission subplan
  3. Click next button

Step 5: apply these additional filters that are based on Side and subplan on the Property screen

  1. Choose all to include all property list side commission subplan
  2. Choose ALL to include all property sell side commission subplan
  3. Click next button

Step 6: apply this rule when the transaction type and accounting codes match these settings

  1. Choose all to include all transaction types (IH, OL, Rental, etc )
  2. Choose all to include all accounting code
  3. Click next button

Step 7: apply these rule criteria for the lead generation and the source of the lead

  1. Choose all to include agent generated and office generated
  2. Choose all to include all seller source
  3. Choose allto include all buyer source
  4. Click next button

Step 8: apply this rule only to agents in these offices

  1. Choose all to include all offices
  2. Click next button

Step 9: apply additional complex criteria for this rule

  1. Leave the advance criteria blank then click the next button

Step 10: formula type

  1. Choose percentage based
  2. Click next button

Step 11: apply this formula for this rule

  1. Click the ellipsis button for percentage field to enter the formula
  1. Enter the percentage
  2. Click save button

Step 11: apply this formula for this rule

  1. Click the ellipsis button for formula is field to enter the formula
  1. Double click on the merge field to add it in the formula field
  2. Click save button

Step 11: apply this formula for this rule

  1. Click next button

Step 12: CAP definition - if there is a CAP, which Total should be used to evaluate if Agent has reached CAP

  1. Skip this step and click the finish button

    • Related Articles

    • Enable Additional Fields on "add person" Screen

      darwin Cloud has a new version of the screen display when adding a new agent, employee, or contact to the software: a new and an expanded form. The version of the screen that is selected in the darwin Cloud settings will display in all screen where ...

    • Commission percentage of list/buy side agents should be 100

      Cause This error occurs when the award % for the list or sell agents does not total 100% on a sales transaction. The most common scenario is that the award % was not filled in for the agent on the deal, and is currently 0%. Fix This error can be ...

    • Security Screen Navigation

      Users To understand the fundamentals of the Security screen, below are its submenus Users Roles Companies Offices Login History How to search and select a user Click Users submenu Click search button Narrow down the search using the following ...

    • Property Accounting screen

      the Accounting summary screen shows you everything in one place In darwin Cloud, the new Accounting summary screen shows you every accounting entry that has any connection to your real estate transactions. This one screen has links to every ...

    • The payments selected for any customer cannot total less than $0

      This error occurs when paying an agent who has two profiles or two different person id in the system. Example: Click Sales menu Click Add payments sub menu Click search Choose the company on the dropdown Click search Select credit memo and invoice ...