Double type not showing numeric seperator

[Carlyn]

Hi

I am very new to Alteryx and just working thru a case study in my training. However, I have fallen at the first hurdle when trying to ensure the data type is numeric. I have followed the instructions and per the attached I configured the relevant field to double, but the results are not showing the number with a numeric separator and when I tried to click the 000 to update this it is greyed out and not bold like it was in the video I was watching. This is preventing me from moving on to the next step as the join will not work. Does anyone know if there is a setting I need to change in the background or what else could be causing this? Thank you

[Deano478]

@Carlyn You can only show these numeric separators if your gonna convert the number to a string 

[Carlyn]

Hi - thanks for replying. I am not sure I understand. The training I was following advised that I needed to change the type from  V_String to Double so that it was numeric and on the video it then changed the Sales column to display with commas. This is not happening on mine. I thought it had to be numeric for the sales value to be multiplied by another number?

[Deano478]

@Carlyn if your just doing simple calcs then the numeric separators like commas should make no difference to the result 

[Ankur_BDO]

   In the results windows you will notice three zeros (sample 000) icon. Click this icon to see the values in results window with comma separator. Maximize the image to see the screen shot top right corner.

[OTrieger]

Hello @Carlyn 

May I asked what is the format of your number flowing for the excel file, American 100.50 or European 100,50? I assume that the values are in European format other wise Alteryx would automatically assign Numeric data type for that field, but you got it as a string. This is my assumption, but I might be wrong.

If your excel containing the later, European format, the minute that you will change the data type to Double it will remove all the values post the coma, in other words you will lose all your decimals. If that is the case you will need first to replace the coma with period so your data will be in a numeric format supported by Alteryx. Alteryx does not understand coma as a delimiter for numbers, only period for the decimals.