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
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
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'
Yellow Belt

Re: How to combine and summarize departments

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

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
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!