---
schema_version: "1"
id: 9fb2e2fb3d845c1caae7a2a7477bfeab963f1776f535ee4eb3db6fb4a77a61b9
title: Create Custom Fields to Capture Cost and Profit Metrics
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/ind/264-0-0/aaf_customize_dpe_revenue_metrics_requirements.md
canonical_url: https://help.salesforce.com/s/articleView?id=ind.aaf_customize_dpe_revenue_metrics_requirements.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: ff35213e289ce6dbd67d0eeedbe46c05714254dbb0137f0ee504e1cd713b5fa1
description: To capture fixed cost and variable cost details, create custom fields on Price Book Entry. Then add those custom fields on the Advanced Account Forecast Fact object so that the data can be written back for each period by the Data Processing Engine job. Additionally, you can add custom fields for other measures that demand planners want to view on the forecast display.
products:
  - Manufacturing
release: "264"
---
# Create Custom Fields to Capture Cost and Profit Metrics

To capture fixed cost and variable cost details, create custom fields on Price Book Entry. Then add those custom fields on the Advanced Account Forecast Fact object so that the data can be written back for each period by the Data Processing Engine job. Additionally, you can add custom fields for other measures that demand planners want to view on the forecast display.

### 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: 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></tbody></table>

1. Add these custom fields to Price Book Entry.
    
    | Field Label | Field Name | Data Type |
    | --- | --- | --- |
    | Fixed Cost | FixedCost\_c | Currency |
    | Variable Cost Per Unit | VariableCostPerUnit\_c | Currency |
2. Add the custom fields to Advanced Account Forecast Fact.
    
    | Field Label | Field Name | Data Type |
    | --- | --- | --- |
    | Fixed Cost | FixedCost\_c | Currency |
    | Variable Cost Per Unit | CostPerUnit\_c | Currency |
3. Add other custom measures as formula fields to Advanced Account Forecast Fact.
    
    | Field Label | Field Name | Data Type | Formula |
    | --- | --- | --- | --- |
    | Actual Gross Margin Percent | ActualGrossMarginPercent\_c | Formula (Currency) | `IF(OrderQuantity <> 0, OrderRevenue - ( ( OrderQuantity * CostPerUnit__c ) + FixedCost__c ), 0)` |
    | Forecasted Gross Margin Percent | ForecastedGrossMarginPercent\_c | Formula (Currency) | `IF(ForecastedQuantity <> 0, ( ForecastedRevenue - ( ForecastedQuantity * CostPerUnit__c + FixedCost__c )) / ForecastedRevenue, 0)` |
    | Actual Profit | ActualProfit\_c | Formula (Currency) | `IF(OrderQuantity <> 0, OrderRevenue - ( ( OrderQuantity * CostPerUnit__c ) + FixedCost__c ), 0)` |
    | Forecasted Profit | ForecastedProfit\_c | Formula (Currency) | `ForecastedRevenue - ( ( ForecastedQuantity * CostPerUnit__c ) + FixedCost__c )` |
    | Total Cost | TotalCost\_c | Formula (Currency) | `(ForecastedQuantity * CostPerUnit__c ) + FixedCost__c` |