Formulas in Free-Form Grids

Review the guidelines in this topic when working with formulas in free-form grids.

Data source types: Oracle Essbase, Planning

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 16-12 shows a grid from an Oracle Essbase data source with Excel formulas in cells C8 and F8.

Figure 16-12 Formulas in Essbase Free-Form Grid in Excel


Shows a valid grid as described in the previous paragraph.

Figure 16-13 shows a grid from a Planning data source with Excel formulas in cells B8 and C7.

Figure 16-13 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.