Numeric data format

[AbdullahMansour90]

Dear all 

I have this data which responds to rates as shown below, it's red as string in alteryx and when i try to change it to number so i can apply formulas to it it all goes to zero except for the above 1 rates, can anyone help in thois? 

Thanks in advance. 

[Maskell_Rascal]

Hi @AbdullahMansour90 

Can you provide some sample data to troubleshoot?

Thanks!

Phil

[Emil_Kos]

Hi @AbdullahMansour90,

It is happening when you are importing the data? 

I think the issue like this can happen because you are using int data type. If you will use Double it will start working.