Adding Supporting Details

Data source types: Planning, Enterprise Profitability and Cost Management, FreeForm

Use the Supporting Details dialog to set how detail items aggregate to cell values in a form.

Note:

Forms 2.0 does not allow adding supporting details to formula cells or to a range of selected cells if it contains a formula cell.

Video

Your Goal	Watch This Video
Learn about using basic Oracle Smart View for Office functionality related to Planning, including adding supporting details.	Entering and Saving Plan Data in Smart View with Oracle Planning and Budgeting Cloud

To add supporting details that calculates values in a form or ad hoc grid:

1. Open a form, and then select the cells.

   You can select one cell or a range of contiguous cells in a row or column. The selection cannot include a combination of rows and columns. Select cells that are in the local currency so that you can write to them.

2. From the provider ribbon or provider ad hoc ribbon, select Cell Actions and then Supporting Details.

   The Supporting Details dialog reflects your cell selection.

3. Enter a description over the initial "untitled" text.

   The text and its associated operator must be unique among children of the same parent. By default, you can enter up to 1,500 characters.

4. Use the buttons to create or change the indented hierarchy to reflect the desired structure and calculations.

   For example, click Add Child to add a line item directly below the selected item.

5. Set the mathematical relationships among the line items by selecting an operator for each of them.

   Select from these operators:

   Operator	Function
   +	Add
   -	Subtract
   *	Multiple
   /	Divide
   ~	Ignore

6. Enter data to set or calculate.

   Enter numbers using the same scaling that was set up for the form.

7. Click Submit.

   Values are dynamically calculated and aggregated before the data is submitted. Data on the form is also submitted.