### Calculation Editor

In a story, the calculation editor allows you to create calculations for a chart or table. In a table, you apply calculations either to the account dimension or to measures. For each type of calculation, a new calculated or restricted member is created for the dimension that you used to create it. You can also use dimension attributes as part of a calculation.

- Calculated Measure
- Perform a mathematical calculation on one or more members of either the account dimension or the measure.
- Restricted Measure
- Restrict the data from a member of the account dimension or a measure so that it excludes certain members of one or more dimensions. For the date dimension, you can pick dynamic values, such as year-to-date or previous quarter.
- Difference From
- Find the difference in a value between two dates.
- Currency Conversion
- For models with currency conversion enabled, calculate a value based on a currency exchange rate.

- Calculated Measure
- Restricted Measure
- Aggregation

(Live models based on HANA calculation views have all of the options.)

In a chart, calculations based on the account dimension can be added as new measures. The figure below shows the supported calculation types.

- You can create calculated measures in the model in cases where they need to be shared across stories.

### How to Create a Calculated Measure

Create a calculated measure in the *Builder* pane. When setting up your calculation, you apply the typical formula functions, conditions, and operators to the data contained in your model. Calculated measures allow you to perform mathematical and Boolean operations on your data.

Watch this video to learn how to create calculated measures.

You can add preset functions, conditions, and operators by selecting options in the Formula Functions list. You can use IF conditional functions, and you can display a list of possible formulas for the function by pressing *Ctrl + Space Bar*.

### Simple Calculations

You can also add simple calculations simply by selecting two measures in a widget, right-click, choose *Add calculation*, and choose the calculation you want.

### Repeating vs. Single

When you add a calculation (or column/row) to a table, you are given the option to add it either as a *Repeating* or *Single* column/row. This option is only applicable if you have more than one dimension in a row/column. In the figure *Simple Calculations* there is only one dimension in the rows, so it does not matter if *Repeating* or *Single* is selected.

However, in the figure *Repeating vs. Single* there is a dimension in the columns, along with the two measures. Choosing *Repeating* adds the calculation to every dimension member column. Choosing *Single* adds it only to the dimension member whose columns you right-click.