Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Attempting to classify values into certain buckets or fields using an if statement

wnewsom4
5 - Atom

I am having a very tough time trying to figure out the formatting for this if statement... it keeps coming up with the error Use ToNumber(...) because the formula resulted in a string value. I a=have attempted to use the formula and I cannot come up with the correct output.

 

Any help is much appreciated.

 

IMG_8519.JPG

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

@wnewsom4 ,

 

 your data type is double.  Please change to vstring. 

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
wnewsom4
5 - Atom

thank you so much! that worked perfectly

Labels