Create Calculated Elements

To add calculated elements to the data source being created:

Click Create in the Calculated Elements step of the Data Source Creation guided process.
In the Create Calculated Element drawer, enter the following information:
1. In the Label field, enter a name for the calculated data element; maximum length 60 characters. It must be unique for the entire data source, including the data elements added in the previous step. For example, enter Vendor Document ID.
2. In the Name field, enter an actual name for the calculated data element; maximum length 60 characters. For example, enter ue_ibu_DocID.
3. From the Type list, select the data type of the data element. Choices include: String, Integer, Double, Date, and Boolean. For example, select Integer.
4. In the Formula field, enter the formula to be used for the data element. You can use current calculated data elements and supported functions.
  As you begin to enter the formula, you can:
  - Select a function from the list that displays based on the entered formula.
  - Hover over a function to view a description and an example of the function.
5. Click the Learn more about functions link to view the syntax and functions supported for creating your formula. For more information, see Supported Functions for Calculated Elements.
6. Select any of the options to create, test, or discard the created formula:
  - Available Elements (): Click to include a current data element in the formula being created.
  - Supported Functions (): Click to include a function in the formula being created.
  - Test Expression: Click to resolve any displayed errors such as circular references.
  - When all errors are resolved, the anticipated value of the formula displays in the Preview Data field.
  - Remove Expression ( ): Click to discard the entered formula.
7. After finalizing the formula for the calculated element, select any of the following options from the Create menu:
  - Create and Create Another: Click if you want to repeat step 2 to continue creating calculated elements in this drawer.
  - Create and Close: Click to close this pane and return to the Calculated Elements: (Optional) Include Calculated Elements in the Data Source.
In the Calculated Elements step of the guided process, perform the following actions:
1. From the Save menu, select any of the following options to save the selected data elements:
  - Save: Click to save the selected information displayed in the Data Elements step.
  - Save and Close: Click to return to the Data Sources log.
2. Click Continue to proceed to the Filters: (Optional) Create Filters for Data Elements step of the guided process.

Related Topics