Multiple options formula

[JorgeVazquez]

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.

[dataMack]

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.

[MarqueeCrew]

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

[Kanderson · Accepted solution]

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.

[JorgeVazquez]

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!