The Custom expression editor is the specific tool within the SAP Analytics Cloud data preparation environment (the "Wrangler") used to perform advanced data transformations on a dataset. It enables users to write custom formulas, including conditional logic such as IF([Dimension] = "Value", "Then", "Else"), to create new columns or modify existing ones. This editor is designed for complex data wrangling tasks that go beyond the standard, pre-defined transformation options.

A. Calculations editor: This is used within a story or analytic application to create calculations (e.g., calculated measures) for analysis, not to transform the source dataset itself.

C. Formula bar: This is a generic user interface element for entering formulas. The Custom expression editor is the specific, feature-rich tool invoked for this type of transformation.

D. Transform bar: This is not a standard or official name for a specific tool in SAP Analytics Cloud for applying conditional transformations.

1. SAP Help Portal

SAP Analytics Cloud

"Applying Custom Transformations to Data in Datasets": "You can use the custom expression editor to create your own transformation formulas... For example

you can use an IF function to create a new column with values based on the values in another column." This document explicitly links the Custom expression editor to the use of IF functions for transforming data in a dataset.

2. SAP Help Portal

SAP Analytics Cloud

"Combining and Editing Data in the Modeler": In the section describing data wrangling

the process shown is to select a column

choose "Add Transform"

and then select "Custom Expression". This action opens the editor where conditional formulas are built to transform the data. This confirms the workflow and the name of the tool.