Error resulted in a string but the field is numeric use tonumber

[Mostafa_Anwar]

Hi All,

i am struggling in this error "resulted in a string but the field is numeric use tonumber" despite the field type as Double in all previous SELECT tools, Also the formula is not provide me the required result, Appreciate your help pls 

[ChrisTX]

It looks like you are using a ToNumber function for a string field [NivelAvance].

Not sure exactly what you're trying to accomplish.  Perhaps just remove the ToNumber?  Why are you thinking you need to use ToNumber?

Can you post some sample data, and list the data type for each field, and the desired output?

Here is a list of all functions:

https://help.alteryx.com/current/designer/functions

Chris

[mguerra1982]

Thanks Cris, I need to get a days from today +2 days when the condition is [NivelAvance]="X" and [Country]="Y"

and with this number of days change the [NivelAvance] to another step. 

I hope you can help me out. 

Thanks. 

[ChrisTX]

Can you post some sample data for input and expected output?

What should your date value be if this condition is NOT met: [NivelAvance]="X" and [Country]="Y"

Here's a guess for some code:

Use a formula tool.  Create a new field, data type Date.

IF [NivelAvance]="X" and [Country]="Y"

  THEN DateTimeAdd(DateTimeToday(), 2, "days")  

  ELSE Null()

ENDIF

Suggested lessons: On the left, under Academy, try the Interactive Lessons.

Here are lessons on Writing Expressions: https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Writing%20...

Chris