Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

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

FrankPereira
5 - Atom

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.

 

 

 

A3R.PNG

 

 

2 REPLIES 2
alberto_herni
9 - Comet

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
5 - Atom

Hi Alberto,

 

It worked. Thanks a lot :)