Calculations in Charts
A calculation (also known as a calculated metric) lets you apply ad hoc analysis to your charts. You can create calculations that are basic mathematical expressions or that contain complex conditional logic. Here are a few examples:
 Sum liquid assets:
[110_cash] + [120_account_receivables] + [130_shortterm_investment]
 Commission based on deal size:
iif([dealsize] >= 100000, [commission] * .05, [commission])
Where to Manage Calculations
In edit mode, you can create, edit, and organize calculations from the Accounts tab in the left panel. Navigate to Dashboards Metrics > <your instance> Metrics. Only calculations have a name and a code.
The following shows set of calculations for Menzi, Inc:
Hover your mouse over a folder and open the more menu. Choose:
 Add Folder. You can nest folders inside other folders.
 Rename Folder. You can rename any folder including <my instance> Metric folder.
 Add Calculated Metric. Create a calculation.
 Delete. Delete a folder. You cannot delete the <my instance> Metric folder.
Hover your mouse over a calculation and open the more menu. Choose:
 Edit. Change the settings, expressions, or drilldown selections on a calculation.
 Delete.
Any calculation that you create is available to anyone who can edit perspectives. They can add your calculation to their charts.
Where to use Calculations
Calculations in Charts
When you add a calculation to a chart, it becomes a data series. You can edit the appearance, data settings, and time settings. For example, you can rename the series, apply a filter, change the series color, or change many more settings.
The following shows a line chart with a calculation Quick Ratio as the data series. After adding the data series to the chart, the calculation was renamed to Liquidity Ratio. The data settings in the chart changes automatically without breaking the reference to the source calculation.
Calculations Within Other Calculations
You can reuse a calculation in another calculation to build complex expressions. Reference the calculation code in the expression. For example, you can use the Quick Ratio calculation in a capital planning calculation:
iif([quick_ratio] > 2.5, [hardware] * 1.05, [hardware])
Version Overrides and Precedence
By default, the version used in a data series on a chart references the default version set at your instance. You can override the version default by specifying a version:
 On the data series
 In the calculation that is added as a data series.
The innermost version referenced in the calculation takes precedence over data settings and the instance default. The outer to inner precedence is:
Outermost (Lowest)  →  Innermost (Highest) 
Instance  Data Series in Chart  Calculation within a Calculation 
The following examples describe various scenarios and potential outcomes in more detail:
Is Version In Calculation?  Does Data Series Override Default Version?  Data Series in Chart Uses 

No: Total_Revenue calculation uses default version:

No : Total_Revenue as a data series defaults to the version selector: 
Version used in calculation: Working Budget, the instance default. Total_Revenue in the chart shows data values based on Working Budget. 
No: Total_Revenue calculation uses default version:

Yes: Total_Revenue as a data series has version set to Forecast: 
Version used in calculation: Forecast Total _Revenue in chart shows data values based on the version set in the data series. 
Yes: Total_Revenue calculation references the Actuals version:

Yes: Total_Revenue as a data series has the version set to Forecast: 
Version used in calculation: Actuals Total _Revenue in chart shows data values based on the version referenced in the calculation, not the data series setting. 
Yes: Net_Income calculation references Total_Revenue calculation and a general ledger account,
where the expression in Total_Revenue is:

No: Net_ Income as a data series defaults to the version selector: 
Version in used in calculation, Actuals The source expression in Total_Revenue references the Actuals version and overrides the reference in the Net_Income calculation. Net_Income in the chart shows data values based on Total_Revenue Actuals less Expenses from the Working Budget, the default version set on the instance. 