KNOWLEDGE BASE

Error "Bad int64 value" Using FLOAT() on a String field in Google BigQuery


Published: 24 Nov 2016
Last Modified Date: 20 Feb 2020

Issue

Using FLOAT () on a string field containing a decimal separator (ex: 12345.67), the following error occurs:

Bad int64 value 12345.67

Environment

  • Tableau Desktop 10.1.0 - 10.1.2
  • Google BigQuery

Resolution

Instead of: FLOAT([DimensionName])

Use: RAWSQL_REAL("CAST (%1 AS FLOAT64)", [DimensionName])
Did this article resolve the issue?