Synced Table from Tableau rounding currency field

159 0
Showing results for 
Search instead for 
Did you mean: 
7 - App Architect
7 - App Architect

I have a table built in Tableau that appears fine on screen, showing the currency fields with 2 decimals.

In the past i had to export as crosstab csv and then use CSV import extension to update records in Airtable. Now i want to just use a directly synced table from the Tableau integration, but it is not working.


1. Biggest issue is currency fields are importing as rounded whole dollars, losing the decimals.

2. Also noticing that currency fields are coming in as text field and unable to convert to currency field.


I have tried changing the number format in Tableau using Number (standard), Number (custom), Currency (standard),Currency (custom), and Automatic. Nothing works.


Any ideas?


Screenshot 2023-09-28 at 7.25.10 AM.png

Screenshot 2023-09-28 at 7.24.25 AM.png

Screenshot 2023-09-28 at 7.24.14 AM.png


0 Replies 0