Spotfire Importing Decimal datatype as Currency

Hi there

I am connceting to a SQL database using the Microsoft Sql Server option.

When importing a field that is decimal in the database, Spotfire imports this as a Current. This becomes problematic down the line e.g. should you wish to use a datafunction that requires a decimal data type.

What are my options here? (I can change the datatype in the database but haven't had joy with this option yet).

All the formatting and transformation options are greyed out so can't do that either.

Any assistance would be much appreciated. 

(1) Answer