The formula bar provides a central location for the administration of formulas and selection of members when setting up grids in Financial Reporting.
You can type selected functions to pick members dynamically. SeeTable 2 for a list of functions that can be used in the Formula Bar and Table 2, Functions Available Only Through Member Selection for a list of functions that cannot be used in the Formula Bar. |
The formula bar contains a text box for the entry of formulas and a drop-down list box of functions to choose from when building formulas. If you select a member in a grid, member selection is activated on the formula bar.
The formula bar is displayed below the toolbar so you can easily access its functionality. It is visible but disabled when you are not using grids.
The Financial Reporting formula bar is similar in functionality and appearance to the formula bar in Excel. You can use the formula bar to perform the following tasks on grids: