Rollup Additional Sales Target Fields

To compare sales performance against the target, the GSP Target Tracker app uses the Opportunity Amount field by default.

However, not every business uses the Opportunity Amount field. For example, you may use ARR (Annual Recurring Revenue) or Margin to compare sales revenue with target.

That is no problem. You can use this custom field with the GSP Target Tracker.

However, there are some configurations you will need to do to get the values rolling up correctly.

Do the following:

• Create three new formula fields on the Opportunity referencing the custom field you wish to use on the Target Record. Depending on your business, your formula return type may be “Number” rather than “Currency.” An example of this would be if you are rolling up physical objects/sales rather than a monetary value.
• These three new formula fields will be used to calculate the following: the Target Field Won Amount, the Target Field Pipeline Amount, and the Target Field Weighted Pipeline Amount.

The formulas for each field are:

Target Field Won Amount:
IF (IsWon = TRUE, CUSTOM AMOUNT FIELD HERE, 0 )

Target Field Pipeline Amount:
IF ( IsClosed = FALSE , CUSTOM AMOUNT FIELD HERE , 0 )

Target Field Weighted Pipeline Amount:
IF ( IsClosed = FALSE , CUSTOM AMOUNT FIELD HERE Probability , 0 )

By rolling these values up to the Sales Target, we can now create the required Formula fields on the Sales Target.

Note the exact API names for each of these fields. You will need them again at a later step.

• Now that you have created the fields on the Opportunity, you need to add them to the Opportunity field set called “Monthly Sales Target.” This field set, included in the GSP Target Tracker package, tells the app which fields to roll to the Sales Target.

At this point, the opportunity’s configuration is complete—remember to click save. Next, you need somewhere to store the rolled-up values on the Sales Target.

• Create the same fields on the Sales Target, but this time, create them as either Number or Currency fields, depending on your Opportunity formulas. We only store the values this time, so there is no need to create formula fields. Make sure the API names of your custom Sales Target fields match the API names of your custom Opportunity fields. This allows the system to match the fields accurately.

Once done, your Opportunity fields will correctly match the Sales Target record.