Create or Edit Oracle BAM Data Control Wizard

7.5 Create or Edit Oracle BAM Data Control Wizard - Calculated Fields Page

Use the Create or Edit Oracle BAM Data Control Wizard - Calculated Fields Page to create calculated fields in the Oracle BAM Data Control query. How? topicid:SOASE947

Element	Description
Calculations List	The calculations list contains all of the calculated fields you created. Fields created here will appear as selectable fields in the fields list and the other pages in the wizard so that you can create calculations, groups, filters, and aggregates on them and include them in tables. By default an empty calculation (Calculation1) appears here. There are some controls located above this list that you can use to add new calculations, rename them, and delete them.
Calculation Builder Box	This box displays the calculation as you build it. You can position the cursor in the box and enter expressions, or use the fields and expressions lists at the bottom of the page to enter elements into the calculation.
Field Controls	The fields list and Insert Field button allow you to select fields from the Oracle BAM data object to use in your calculations. Select a field from the list and click Insert Field. Any calculated fields you create will appear in the list.
Expression Controls	The expressions list and Insert Expr button allow you to select from the list of valid expressions to build your calculation. Select an expression from the list and click Insert Expr.
Grouping Controls	The Group By button and field allow you to select a field to group by in the calculations page. This is useful if you are building a flat query and wish to group your list by a particular column value.
Keypad Controls	The keypad controls located at the bottom right of the page present you with options for entering numbers and symbols in your expression. You can also enter any of these numbers and symbols by typing directly into the calculation builder box.