alteryx Community

# Alteryx Designer Desktop Discussions

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

## Multiple options formula

7 - Meteor

Hi community,

I am trying to classify a large amount of information into the following banding.

 RevenueBanding A = <100 B = 100 - 1,000 C = 1,001 - 2,500 D = 2,501 - 5,000 E = 5,001 - 7,500 F = 7,501 - 10,000 G = 10,001 - 20,000 H = 20,001 - 50,000 I = 50,001 - 100,000 J = 100,001 - '250,000 K = 250,001 - 500,000 L = 500,001 - 1,000,000 M = 1,000,001 - 2,000,00 O = >4,000,001

I thought I could use the "switch" formula but I am getting an error everytime.

Does anybody have faced this before? Any ideas on what Alteryx tool I can use to do this?

Thank you.

4 REPLIES 4
12 - Quasar

You can use a case statement in the formula tool, or a tool specifically designed to do this is called the 'Tile Tool'- one of its options is to pick specific cutoffs, so thats the one to choose for your case.

20 - Arcturus
If [field] < 50 then 'A' elseif
[field] < 100 then 'B' else 'C'
Endif

Your ranges are mutually exclusive. This approach will work for you.

Sent from my iPhone
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
10 - Fireball

The expressions mentioned below would work perfectly. However, this made me think of the tile tool. You can adjust it to use manual groupings. I have attached an example.

7 - Meteor

Thank you all for your inputs. I am using the "title" tool and an additional "Find/Replace" to match my labels with the title num in the output.

I really appreciate your help on this.

Gracias!

Labels