---
schema_version: "1"
id: caab8e0614b497cfaebafc7cdde8cecd6076dda9cb34b3574e8a9e604899f563
title: Create a Formula Field
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_formula_expression_library.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_formula_expression_library.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: c300bc37ae24dde8bfab75e530fc876f5d5667f16b4554529b0c156924da1656
description: When you create a Data 360 data stream, you can choose to generate more fields. These supplemental fields can be hard-coded or derived from other fields in the data stream.
products:
  - Data 360
release: "264"
---
# Create a Formula Field

When you create a Data 360 data stream, you can choose to generate more fields. These supplemental fields can be hard-coded or derived from other fields in the data stream.

Before you begin, refer to [Considerations for Formula Fields](https://help.salesforce.com/s/articleView?id=data.c360_a_considerations_formula_fields.htm&release=264.0.0&type=5 "Refer to these considerations when creating formula fields in Data 360.") to understand the guardrails applicable for creating a formula field.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/images/icon_note.png)

Note Formulas are refreshed during a full or incremental data stream refresh, and get recalculated only if a record has changed.

1. On the New Data Stream page, click **New Formula Field**.
2. Provide the following:
    1. Field Label: The field label acts as the display name for a data stream field.
    2. Field API Name: The field API name acts as the programmatic reference for a data stream field.
    3. Formula Return Type: The data type corresponding to the newly derived field.
        
        Options include: Text, Number, DataTime, Date, Email, Phone, URL, Percent, and Boolean.
        
        ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/images/icon_note.png)
        
        Note The Salesforce connectors and Connector services don’t support these data types: Email, Percent, Phone, Boolean, and URL for the Formula Return Type.
3. Construct your formula in the syntax editor. Within the editor, you can reference a combination of:
    1. Fields present in the data stream.
    2. Free form text
    3. Functions
    4. Operators
4. Validate the constructed formulas using the formula testing panel:
    1. Inputs: The panel displays all source fields referenced in your formula.
    2. Text Boxes: Next to each referenced source field in the input, type in a sample value to evaluate the expression.
    3. Test Button: To evaluate the expression that is returned based on the sample value inputs, click the Test Button.
    4. Output: See the expected output value.
5. Click **Save**.

The formula expression gets added as a new field in the data stream. The formula is assessed for any syntax errors. Before you deploy the data stream, delete a formula expression field as an inline action.

- **[Considerations for Formula Fields in Data 360](https://help.salesforce.com/s/articleView?id=data.c360_a_considerations_formula_fields.htm&release=264.0.0&type=5)**  
    Refer to these considerations when creating formula fields in Data 360.
- **[Supported Library Functions](https://help.salesforce.com/s/articleView?id=data.c360_a_supported_library_functions.htm&release=264.0.0&type=5)**  
    In the Data 360 data library, you can choose functions and operators. You can nest functions.
- **[Supported Library Operators](https://help.salesforce.com/s/articleView?id=data.c360_a_supported_library_operators.htm&release=264.0.0&type=5)**  
    Learn more about the supported library operators in the Data 360 syntax editor.