---
schema_version: "1"
id: 6a721b36ef46c2c49fd2aa6c2412bc7c82060b16cf27d66eacbd2f41432c139a
title: Connector Fields and Calculations in Salesforce Spiff Reports
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_report_fields.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_report_fields.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 09e383be1728b57eb584c2428942a4f030c6f2114b70f74a0a3de61d683d89dd
description: When you’re using connector fields or calculations in Salesforce Spiff reports, encapsulate each those items in their own calculated field.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# Connector Fields and Calculations in Salesforce Spiff Reports

When you’re using connector fields or calculations in Salesforce Spiff reports, encapsulate each those items in their own calculated field.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available for an additional cost in: <strong>Professional</strong> Edition with Web Services API Enabled</td></tr></tbody></table>

## Connector Fields

Connector fields sync data directly from an external data source‌, such as Salesforce, or by manual upload. To use a connector field in a payout rule calculation, we recommend that you encapsulate the field in a separate calculated field. For example, instead of using the connector field ARR\_\_c directly, create a calculated field named DealARR that references ARR\_\_c.

This practice also makes it easier to replace one connector field with another when you update your plans. For example, maybe you want to change ARR\_\_c to DealAmount. When you encapsulate the connector field in a calculated field, the only change to make is in the calculated field. Otherwise, you have to find every calculation where you use the connector field and change it.

## Calculations

Encapsulating portions of calculations is important for reports for these reasons.

- Encapsulations are more human-readable.
- Each encapsulation becomes available as a metric or field to show in commission statements.
- Encapsulation saves memory. The logic can be calculated once and then reused.
- Encapsulation helps identify the calculation's checkpoints.
- Encapsulation helps you troubleshoot errors more easily.

For example, consider this calculation before encapsulation.

```
=if(EndOfPeriod = end_of_quarter(EndOfPeriod), 1, 0) * BonusTotal
```

Encapsulate the `if()` function is a calculated field, IsEndOfQuarter.

```
=if(EndOfPeriod = end_of_quarter(EndOfPeriod), 1, 0)
```

Then, you have a similar calculation.

```
=IsEndOfQuarter * BonusTotal
```

#### See Also

- [Connectors for Salesforce and Third-Party Data in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_connector.htm&release=264.0.0&type=5 "Sync data from objects and fields in Salesforce or third-party providers for use Salesforce Spiff. Connector fields in Spiff represent the fields synced from the source data, versus calculated fields created in Designer.")