Multi field Formula to choose values more than 100,000 ( It has total 122 columns)

[FrankPereira]

Hi 

I'm new to Alteryx - still trying to figure how different tools works. If the below question is silly then i'm really sorry.

I have an excel sheet with 122 columns and I wanted to select only those values which are more than 100,000. I tried to use this formula - if [_CurrentField_] > 100000 then [_CurrentField_] else "0" endif. however it's throwing an error.

Thanks in advance.

[alberto_herni · Accepted solution]

Hi Frank,

By the error message you're getting seems to me that the field type for your columns is a string and you're applying a formula based on a number calculation, so I would suggest you to insert a select tool, before the Multi-Field Formula tool, and change the data type of the columns to Double. Another option is to follow the error message and use the ToNumber(...) formula.

Hope that helps!

Regards,

AlbertoHM

[FrankPereira]

Hi Alberto,

It worked. Thanks a lot :)