Calculation Unexpectedly Returns Scientific Notation When Connecting Live to Oracle
Published: 22 Nov 2016
Last Modified Date: 03 Nov 2017
IssueWhen 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.
Use an extract. For more information, see Extract Your Data in Tableau Help.
Rewrite the calculation to use multiplication instead of division.
Additional InformationThis 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.