# Arithmetic Measure

Arithmetic measures allow you to perform simple calculations with measures in a visualization.
A calculated **arithmetic measure** always references two measures, therefore the visualization must contain two measures at least.

## Supported operations

Although a visualization can contain multiple measures, you can perform arithmetic operations with exactly only **two** measures.

The following arithmetic operations are supported:

Operation | Arithmetic measure operator | Expression formula | Example |
---|---|---|---|

Sum | `sum` | =A+B | = Q1 revenue + Q2 revenue |

Difference | `difference` | =A-B | = revenue in 2017 - revenue in 2016 |

Product (Multiplication) | `multiplication` | =A*B | = price per unit * number of units |

Ratio | `ratio` | =A÷B | = gross profit / net sales |

Change | `change` | =(A-B)÷B | = (this month revenue - last month revenue) / last month revenue |

By default, the result data of a `change`

operation is returned as a percentage in the `#,##0.00%`

format. The format cannot be overridden.

All the other operations return data in the default `#,##0.00`

format.
To change the format, use the `format`

attribute of the measure (see the examples).

## Arithmetic measure structure

To add an arithmetic measure to a visualization, use the `newArithmeticMeasure`

factory function:

```
newArithmeticMeasure(operands, operator, modifications)
```

An arithmetic measure can reference the following as its **operand**:

- Simple measures
- Derived measures (see Time Over Time Comparison)
- Another arithmetic measures

You can specify operands either by their `localIdentifier`

or by their value, and the factory function will extract
the local identifier for you.

The **operator** can be one of the following:

`sum`

`difference`

`multiplication`

`ratio`

`change`

The **modifications** part is optional and is a function with a single parameter, which is an object with functions that you can use to override the measure's `format()`

or `alias()`

.

If arithmetic measures reference each other in an infinite loop or the referenced measure is not found in the visualization (there is no measure with the referenced *localIdentifier*), the error message is rendered instead of the visualization.

## Examples

### A difference between two measures - arithmetic measure constructed using localIdentifier references

```
import { newMeasure, newArithmeticMeasure } from "@gooddata/sdk-model";
import { PivotTable } from "@gooddata/sdk-ui-pivot";
const measures = [
// the first simple measure (operand)
newMeasure("boughtProductsIdentifier", m => m.alias("Bought products from supplier")),
newMeasure("soldProductsLocalIdentifier", m => m.alias("Sold products to customers")),
newArithmeticMeasure(
["boughtProductsLocalIdentifier", "soldProductsLocalIdentifier"],
"difference",
m => m.alias("Products remaining in warehouse")
)
];
<PivotTable
measures={measures}
/>
```

### Calculation with a derived measure (percentage change between two years)

The result of a `change`

operation is returned as a percentage value in the default `#,##0.00%`

format. This example
demonstrates passing measures by value to the different measure factory functions.

```
import { newMeasure, newPopMeasure, newArithmeticMeasure } from "@gooddata/sdk-model";
import { PivotTable } from "@gooddata/sdk-ui-pivot";
const currentYear = newMeasure("measureIdentifier", m => m.alias("Current Year"));
// derived - data from previous year
const previousYear = newPopMeasure(currentYear, "attributeDisplayFormYearIdentifier", m => m.alias("Previous Year"));
// arithmetic measure with custom format
const change = newArithmeticMeasure(previousYear, currentYear, "change", m => m.alias("Change between years").format("$#,#0.0%"));
const measures = [
currentYear,
previousYear,
change
];
<PivotTable
measures={measures}
/>
```

## More information

See the live examples.