ERROR in formula

[Sa743liz-]

Hi I'm trying to do this formula but it doesn't work 

The desire output need to look like this: 

[ChrisTX]

In the THEN clause, you are outputting a string, the ELSE clause is outputting a number.

You'll need to convert the number to a string.  The same field cannot contain string and numeric data.

[Sa743liz-]

V_WString

[ChrisTX]

If the field [12.31.21 MarketPriceBase] is a string, you can't use it in a calculation, like you're trying to do in the first part of the IF formula.

Look at the ToString function:  https://help.alteryx.com/20221/designer/functions

Can you post sample input data in a table (not a picture)?

[Sa743liz- · Accepted solution]

No problem I fix the problem using a select before the formula. Thank you