Formulas in Free-Form Grids

Data source types: Essbase, Planning, Oracle Planning and Budgeting Cloud Service, Financial Management

You can enter Excel formulas in cells that can contain comments.

Note:

Excel formulas are not saved to the provider server in the free-form worksheet. For example, if you use the Save Ad Hoc Grid command with a Planning free-form or ad hoc grid, the formulas are not saved. However, you can retain formulas in a worksheet by performing a Save in Excel and saving the workbook.

Figure 77, Formulas in Essbase Free-Form Grid in Excel shows a grid from an Essbase data source with Excel formulas in cells C8 and F8.

Figure 77. Formulas in Essbase Free-Form Grid in Excel

Shows a valid grid as described in the previous paragraph.

Figure 78, Formulas in Planning Free-Form Grid in Excel shows a grid from a Planning data source with Excel formulas in cells B8 and C7.

Figure 78. Formulas in Planning Free-Form Grid in Excel

Shows a valid grid as described in the previous paragraph.

For information about unexpected behavior that may occur, see Actions That May Cause Unexpected Behavior.