Properly Setting Up Formula Definitions in Financial Reporting--Avoiding Cross-Axis References (Doc ID 1103717.1)

Last updated on DECEMBER 28, 2023

Applies to:

Purpose

This article is intended to provide some information on setting up formulas in Financial Reporting. Specifically, formulas that reference other rows and columns should be defined so as to avoid the use of cross-axis references. A cross-axis reference occurs when a formula row includes a general column reference (or vice-versa - when a formula column includes a general row reference) as opposed to a specific cell reference.

Scope

A reference such as [B] refers to an entire column of a report -- Column B. If a formula is defined such that it refers to [B], then the entire column is being addressed, instead of an individual cell within Column B (e.g., [B,3]). This can lead to undesired and/or erroneous results.

Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.