---
schema_version: "1"
id: 8aba1ab625f24342d3fa59027d3a714ddb950c6d38eb7dd2e50a6e4159744faa
title: Upgrade or Edit Formulas for Converted Recipes
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_recipe_transformation_simple_formula.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_transformation_simple_formula.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 2e1d4f0981f0601d70278eea5598c32bed51914e08d1cd595b725e84bd9b7113
description: You see a different formula editor if your recipe was converted from Data Prep Classic to Data Prep and your formulas couldn’t automatically upgrade. You’re still able to edit and use these formulas, but to get the most formula options through EA-SQL and best experience, recreate the formula in the Data Prep recipe editor.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Upgrade or Edit Formulas for Converted Recipes

You see a different formula editor if your recipe was converted from Data Prep Classic to Data Prep and your formulas couldn’t automatically upgrade. You’re still able to edit and use these formulas, but to get the most formula options through EA-SQL and best experience, recreate the formula in the Data Prep recipe editor.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d111794e25">User Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d111794e25 ">To create a recipe:</td>
            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d111794e25 ">Edit CRM Analytics Dataflows OR Edit Dataset Recipes</td>
          </tr>
        </tbody>
      </table>

1. In a Data Prep recipe that was converted from Data Prep Classic to Data Prep, select a transformation with a formula.
    
    A formula that was not converted automatically looks like this. Continue to use these instructions to upgrade or edit your formula.
    
    ![The legacy Formula editor.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_integrate_formula_recipe_transformation_formula_editor_legacy.png)
    
    If the editor instead looks like this one, your formula was converted successfully and you use the [Data Prep recipe formula editor instructions](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_transformation_formula.htm&release=264.0.0&type=5 "In CRM Analytics, create a column in a Data Prep recipe that displays values based on a formula calculation. The calculation can include input from other fields in the same row or across rows. For example, you can create a Profit column based on input from Revenue and Cost columns. Enter formulas in EA-SQL format. EA-SQL is a collection of standard and custom functions for numeric, string, and date data.") instead.
    
    ![The Data Prep recipe editor.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_recipe_formula_editor.png)
2. To upgrade your formula:
    1. Copy and save your original formula and select **Switch To SQL Editor**. The Data Prep recipe formula editor opens.
    2. Recreate your original formula using the correct syntax described in the [Data Prep recipe formula editor instructions](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_transformation_formula.htm&release=264.0.0&type=5 "In CRM Analytics, create a column in a Data Prep recipe that displays values based on a formula calculation. The calculation can include input from other fields in the same row or across rows. For example, you can create a Profit column based on input from Revenue and Cost columns. Enter formulas in EA-SQL format. EA-SQL is a collection of standard and custom functions for numeric, string, and date data.").
3. To edit your formula without upgrading, make your edits following the same syntax used when the formula was originally written. Do not select to switch to the SQL editor.
4. If needed, change the label of the calculated column.
5. When you have completed the formula, click **Apply** to add the transformation to the Transform node.
    
    The new formula column appears in the recipe preview.
6. To view the Graph area, click the Collapse button (![Collapse button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_button_collapse.png)).
7. Save the recipe.

- **[Numeric Operators and Functions for Unconverted Formulas](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_numericfunctions_simple.htm&release=264.0.0&type=5)**  
    Use numeric functions to calculate values from measures in your recipe. For example, you can round, truncate, and determine the absolute value of a number. The arguments for numeric functions can be numbers or measure columns. If your recipe was upgraded to Data Prep, but your recipe doesn’t convert, this topic is for your unconverted recipe.
- **[String Functions for Unconverted Formulas](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_stringfunctions_simple.htm&release=264.0.0&type=5)**  
    Use string functions to create values based on other strings. For example, you can change the casing of text strings, concatenate values from multiple columns, and replace values. The arguments for string functions must be text strings or dimension columns. If your recipe was upgraded to Data Prep, but your recipe doesn’t convert, this topic is for your unconverted recipe.