Use the Formula Assistant

Steps

Open the Formula Assistant:
From sheets, click the
Formula Assistant
button in the toolbar.
From custom calculation in reports, right-click the element and select
Formula Assistance
.
For calculated accounts and shared formulas, click the
Formula Assistant
link in the settings.
Click an account or column from the
Account
section on the left.
When you select an account, the account name and code appears in the
Account Term Modifiers
section. We don't recommend that you reference system accounts from cube sheet cells or cube accounts. See FAQ: What's the best way to reference a system account from a cube sheet?.
When you select a modeled sheet column, the ROW.ColumnName appears in the
Account Term Modifiers
section.
(Optional) From the
Account Term Modifiers
section, use the drop-down prompts to add modifiers for time, levels, custom dimensions, and attribute.
You can't select modifiers for modeled accounts that reference columns using the ROW syntax. When you reference a row, the formula uses the modifiers populated for the specific row.
Click the green check mark.
The account term moves to the
Formula
section.
Select formula functions.
Click the buttons along the top to add to common functions to the
Formula
section.
Or, use the
Function
drop-down menus and click
Insert into Formula
.
Continue to add account terms and functions to complete your formula.

Examples