How to combine and summarize departments

Reply
Highlighted
Yellow Belt

How to combine and summarize departments

 

I'm trying to combine/summarize departments with the following beast mode:

 

CASE WHEN 'Department' = 'EMEA : Africa' THEN 'EMEA'
WHEN 'Department' = 'EMEA : Central Europe' THEN 'EMEA'
WHEN 'Department' = 'EMEA : Middle East' THEN 'EMEA'
WHEN 'Department' = 'EMEA : Northern Europe' THEN 'EMEA'
WHEN 'Department' = 'EMEA : Southern Europe' THEN 'EMEA'
WHEN 'Department' = 'APAC : ASEAN' THEN 'APAC'
WHEN 'Department' = 'APAC : Australia & New Zealand' THEN 'APAC'
WHEN 'Department' = 'APAC : China & Taiwan' THEN 'APAC'
WHEN 'Department' = 'APAC : Korea' THEN 'APAC'
WHEN 'Department' = 'APAC : Singapore' THEN 'APAC'
WHEN 'Department' = 'NA : CENTRAL + WEST (TB) : North Central' THEN 'CENTRAL + WEST'
WHEN 'Department' = 'NA : CENTRAL + WEST (TB) : Northwest' THEN 'CENTRAL + WEST'
WHEN 'Department' = 'NA : CENTRAL + WEST (TB) : Rocky Plains' THEN 'CENTRAL + WEST'
WHEN 'Department' = 'NA : CENTRAL + WEST (TB) : Southwest' THEN 'CENTRAL + WEST'
WHEN 'Department' = 'NA : CENTRAL + WEST (TB) : TOLA' THEN 'CENTRAL + WEST'
WHEN 'Department' = 'NA : EAST + LATAM (JM) : LATAM' THEN 'EAST + LATAM'
WHEN 'Department' = 'NA : EAST + LATAM (JM) : Mid-Atlantic' THEN 'EAST + LATAM'
WHEN 'Department' = 'NA : EAST + LATAM (JM) : Northeast' THEN 'EAST + LATAM'
WHEN 'Department' = 'NA : EAST + LATAM (JM) : Southeast' THEN 'EAST + LATAM'
ELSE 'Other' END

 

The formula is being validated, but everything is falling into the 'Other' bucket. 

 

Any ideas?


Accepted Solutions
Highlighted
Major Brown Belt

Re: How to combine and summarize departments

Tildas are used for field names. Single quotes are used for strings and dates. 

Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'

View solution in original post


All Replies
Highlighted
Major Brown Belt

Re: How to combine and summarize departments

make sure  your field names have a tilda around them (`) not a single quote.

Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'
Highlighted
Yellow Belt

Re: How to combine and summarize departments

Are tildas used for everything, or are single quotes used at times?

Highlighted
Major Brown Belt

Re: How to combine and summarize departments

Tildas are used for field names. Single quotes are used for strings and dates. 

Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'

View solution in original post

Announcements
Coming Soon: Weekly Virtual User Meet-ups to answer all your questions! Stay tuned for more details to come this week.