Formulas are preserved in ad hoc grids when you add comments or use Refresh, Keep Only, Remove Only, Zoom In, or Zoom Out. When you zoom, referential formulas are updated with their new relative positions.
Note: | After zooming in or out, the location of the formula is calculated based on the first occurrence of a member on any row or column. If member names are repeated, zooming in or out may cause the formula location to be wrongly calculated. Oracle recommends that you do not use Zoom In and Zoom Out in grids containing repeated members and formulas that refer to them. |
Formulas are not preserved if you use Pivot, clear the grid, retrieve data without saving the grid, or change alias tables.