Numeric data format

Question

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.

Emil_Kos · Answer

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.

Maskell_Rascal · Answer

Hi @AbdullahMansour90

Can you provide some sample data to troubleshoot?

Thanks!

Phil