Fixed Decimal values must be of the form: -nnn.nn

[traceystone]

Hello,

I have a workflow that keeps giving me fixed decimal conversion errors.  Not sure where to go from here. Attached are 2 csv files and the workflow. Suggestions?

[ShankerV]

Hi @traceystone 

The problem is because of the - here.

[ShankerV]

Hi @traceystone 

I have removed the rows with - to empty and it avoid the warning message.

Now there is NO warning message related to Select (8) tool related to Fixed Decimal Conversion errors.

Many thanks

Shanker V

[apathetichell]

throw it in a multi-field formula. Select the field you want to convert...

if isnumber([_CurrentField_]) then tonumber([_CurrentField_]) else null() endif

unclick the new column option - and change it to fixed decimal. both "" and "-" are strings. use 0 or null() for empty numeric fields.