INT(TRIM(LEFT("[FIELD]", 4) ) )
This is the closest I've got so far.
Some fields had a range in them.. Like 1546.00-2923.00
Others 0.00, others 1513.00
I'm guessing at some point in the 30+ million rows there's some text...
What can I do without messing with the source database?
I've managed to get around a vaguely similar issue in the past using RAWSQL.
This thread might just give you some clues...
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...