Data Types for Decimals/Currency Appsheet > Bigquery

I am a little stumped trying to use BigQuery as a data source. 

One table has a field for price/currency. The table in BigQuery has a data type of FLOAT, initially I had Appsheet set to Price but I get a error that reads:

 Cannot create parameter HEADER_TOTALr0 of type Float64 with value 4.35 of type System.Decimal

I tried to test other data type configs on both sides but regardless of what I have set for datatype on Appsheet or BigQuery.  

Has anyone come across this? 

I've been using a small CloudSQL instance with the same app for quite some time without issue. 

0 27 1,010
27 REPLIES 27
Top Labels in this Space