Formula filed giving null output

[videet]

I converted my string fields to Integer and performed addition but its giving me null 

Can you please help?

Earlier when filelds were string by default it was appneding zero in form

[Qiu]

@videet 

Most likely at least one of your fields was not convered to integer successfully.

Do you observe any warning massage from the results panel of Alteryx?

And please check the result panel by clicking the output anchor of Select tool to see if all data is as you intended to be?

[videet]

I am getting 2 warnings

1. Lost information in translation

2.Conversion error limit reached

[Emil_Kos]

Hi @videet ,

can you send us a data sample? 

Usually, the reason is that there are some unnecessary characters. Spaces, dots, commas and are preventing Alteryx from doing successfully conversion. 

[Qiu]

@videet 
First of all, most of your data is not Integer in nature.

Try to change to Double data type and increase the data size.

Then we can see from there.

[videet · Accepted solution]

@Qiu ,

After changing it to double getting error at only one select filed

[Qiu]

@videet 
Like I suggested, increase the Data Size from 8 to 20?

[videet]

@Qiu ,

Size field is grayed out how can i change?

[Qiu]

@videet 

Thats strange.

Can you send a sample of your data of input in Excel Format, if you can?