---
schema_version: "1"
id: 854f1e2281aaf0b896e5598bcc6384932a382c4553c9f21b8c070b0d2d6eefe3
title: Materialise Calculations in Your Extracts
collection: tableau
version: current
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/current/en-gb/pro/desktop/extracting_optimize.md
canonical_url: https://help.tableau.com/current/pro/desktop/en-gb/extracting_optimize.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 1e7a50fb3125111ce4c605e2ca2558caf9bf874e7909b328f9d8f1f68c75d9da
description: Materialize calculations in an extract to speed up future queries.
---
[Skip to main content](#main-content)

# Materialise Calculations in Your Extracts

You can use the Compute Calculations Now option to materialise calculations in your extract. When calculations are materialised, certain calculations are computed in advance and its values stored in the extract. Depending on the complexity of the calculations used in your extract, this can potentially speed up future queries by allowing Tableau to compute certain calculations in advance. Tableau can then use the precomputed value rather than computing the value each time a query against a calculation is made.

If the formula for a calculation that Tableau has already materialised changes or the calculation is deleted from the data source, the materialised calculation is removed from the extract until you use the Compute Calculations Now option again.

## When to materialise calculations

You should not use the Compute Calculations Now option for all your extracts. Instead, try this option only when the query performance of your extract is slow as a result of complex calculations, such as string manipulations and regular expressions.

## Materialise calculations

To materialise calculations in your extract, do the following:

1. In Tableau Desktop, select the extract data source from the Data menu.
2. Select Extract > Compute Calculations Now.

### Materialise calculations in extracts already published to Tableau Cloud or Tableau Server

If you need to retroactively materialise calculations in extracts that are already published to Tableau Cloud or Tableau Server, you have the following options:

- You can download the extract, open the extract in Tableau Desktop, use the Compute Calculations Now option (as described above), and then republish the extract.
- As a site administrator or data source owner, you can use tabcmd to refresh the published extract with the `--addcalculations` option to materialise the calculations. For more information about the tabcmd command option, see [refreshextracts](https://help.tableau.com/current/online/en-gb/tabcmd_cmd.htm#id4cdb3410-1c41-4dad-b1d2-306542ac9b32) in the Tableau Cloud Help or [refreshextracts](https://help.tableau.com/current/server/en-gb/tabcmd_cmd.htm#refreshextracts_workbook-name_or_datasource-name) in the Tableau Server Help.
    
    **Note:** Materialising calculations can increase the size of the extract.

## Calculations that cannot be materialised

The following calculations cannot be materialised:

- Calculations that use unstable functions such as NOW() and TODAY()
- Calculations that use external functions such as RAWSQL and R
- Table calculations
- Level of detail (LOD) calculations
- Calculations that use column groups, until the dependent column group is materialised with an extract refresh