You are designing an income statement report with the help of Financial Reporting Studio. You add row numbers 3, 4, and 5 to reflect the balances for three different expense accounts and row number 6 to reflect the sum of row numbers 3, 4, and 5. Which formula should be used on row number 6 to calculate the sum?

In Oracle's Financial Reporting Studio, a range of rows or columns in a formula is specified using a colon (:) as the separator between the starting and ending member. The entire reference is enclosed in square brackets. Therefore, [3:5] correctly represents the range of rows from 3 through 5, inclusive. The formula in row 6 to sum these rows would be Sum([3:5]). The option correctly identifies the syntax for the range component of this formula.

A. The semicolon (;) is not a valid range operator in Financial Reporting Studio formulas. It is used in some other contexts but not for defining a contiguous range.
B. The comma (,) is used to specify individual, non-contiguous members in a list, not a continuous range (e.g., Sum([3,5]) would sum only rows 3 and 5).
C. This option uses incorrect syntax. Braces {} are not used for row references, and the numbers are not enclosed in the required square brackets [].

1. Oracle® Cloud, Designing with Financial Reporting for Oracle Enterprise Performance Management Cloud, Release 24B, F94239-02, Chapter 6: Working with Formulas, Section: "Using a Range". The documentation states, "To specify a range of rows, columns, or cells, use a colon (:) separator." It provides examples like Sum([1:5]).