You can use the PurgeChar() funtion in the script or in the front end to get rid of the currency character. I think that's the one affecting some rows and Sense is not able to recognize those values as numeric values.
I think something like
should work. Review the enclosed qvf file.