Formula [Edit menu] (Financial Statement Editor)

Alerts and notices
Leave feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.

Characters left:

Important reminder!

Licenses for Payroll CS, Trial Balance CS, and Write-Up CS (but not Engagement CS) permanently expired on March 1, 2017.

For details, see CSA license expiration 2017 – frequently asked questions.

Some processes documented in the Help & How-To Center are no longer applicable, due to the discontinuation of these CSA modules.

As an alternative to selecting an account group from the Amounts field of the Row Properties box, you can enter a formula. As elements of the formula you may choose account groups , single accounts, periods, storage amounts, additional amounts, locations, departments, manually entered amounts, and/or amounts from a column, row, or cell. For certain elements, you may choose to specify the period, year, and amount type.

From the Financial Statement Editor window and under the following conditions, choose Edit > Formula or press F5:

To construct a formula, first choose the type of element that you wish to include in the formula by clicking the appropriate option. (Note that the options available for selection depend on the type of cell or row that is currently selected.) Next, in the list-pane in the center of the Formula dialog, highlight the appropriate item and then click the operator that you would like to follow that item. If applicable, you may specify the period, year, and amount type before clicking the operator. When you have selected the last element of the formula, click the = button and then click OK to save the record and close the dialog.

If you select an individual cell (rather than an entire row), you must define a valid formula for that cell (in the Contents field), along with a default period indicator and amount type. If you do not, no data will print on the statement.

Related topics

Editing financial statements, overview

Using formulas

Creating and editing financial statements

Using period indicators

Using period indicators in percent columns and formulas

Period indicators available for selection in financial statements

Share This