KNOWLEDGE BASE

Calculation Unexpectedly Returns Scientific Notation When Connecting Live to Oracle


Published: 22 Nov 2016
Last Modified Date: 04 Jul 2017

Issue

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.

Environment

  • Tableau Desktop
  • Oracle

Resolution

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, because Tableau Desktop has to query the Oracle data source in order to refresh the extract.
Did this article resolve the issue?