Change the test query to do a Sum()
Sum should work against the numeric value of the field
When ingesting records for SQL, try to parse strings to get a numeric value to allow for more flexibility in the input.