KNOWLEDGE BASE

Calculation Changes when Using Extract


Published: 25 Nov 2014
Last Modified Date: 28 Feb 2017

Issue

When extracting data, a calculated field may turn red and display as invalid. When examining the formula for the calculated field, it may use an old definition for the field instead of the updated definition for the field

Environment

Tableau Desktop

Resolution

Regenerate the extract using the following steps:
  • Right click on the data source and select Extract > Remove
  • In dialogue that appears, select Remove the extract and delete the extract file.
  • Right click on the data source and select Extract

Cause

The extract is corrupted and is retaining the old definition of the calculated field, over-riding the workbook definition of the calculated field. Forcing a complete regeneration of the extract allows the up to date definition to replace the old definition.
Did this article resolve the issue?