Calculation Unexpectedly Returns Scientific Notation When Connecting Live to Oracle

Published: 22 Nov 2016
Last Modified Date: 03 Nov 2017


When connecting to an Oracle data source live, calculations that behave as followed return scientific notation instead of the expected standard number format:
  • With the calculation, you are attempting to convert a numeric text value into a number with either INT() or FLOAT().
  • With the calculation, you are attempting to include the converted number in an expression that uses division.
  • With the calculation, you are attempting to convert the whole expression into a string.


  • Tableau Desktop
  • Oracle


Option 1

Use an extract. For more information, see Extract Your Data in Tableau Help.

Option 2

Rewrite the calculation to use multiplication instead of division.

Additional Information

This issue may also occur when refreshing an extract in Tableau Desktop 10.3 and older, because Tableau Desktop has to query the Oracle data source in order to refresh the extract. Starting in Tableau Desktop 10.4, refreshing the extract will not cause this issue.
Did this article resolve the issue?