4 Replies Latest reply on Jul 6, 2017 2:48 AM by Khalid Baker

# How can I create formula for Key Brands?

Hey Everyone;

I am trying to list certain brands as key brands and set the rest as others. The logic is based on Countries so a brand could be key in one country and listed as others in another country.

 Australia Brand A Food Australia Brand B Beverage Australia Brand C Food Australia Brand D Beverage Australia Brand E Food Australia Brand F Beverage Japan Brand A Food Japan Brand B Beverage Japan Brand C Food Japan Brand P Beverage Japan Brand Q Food Japan Brand R Beverage China Brand AB Food China Brand AA Beverage China Brand AC Food China Brand S Beverage China Brand T Food Oman Brand V Beverage Oman Brand LT Food Oman Brand GG Beverage

Any brand underlined would be considered Key rest would be others.

Appreciate all the help

Kind Regards;

Khalid B

• ###### 1. Re: How can I create formula for Key Brands?

Hi Khalid

What is the logic for item being key item

is it simply what you have underlined? or there is any solid computations such as item being either highest performing or lowest performing under each entity type?

1. If logic is simply as you have marked. I would suggested create a calculated field

Country + Brand + Entity   and create a group based on this calculated field with all key item combinations marked as key and rest as others.

2. based on value

see which one of these suits your requirement

• ###### 2. Re: How can I create formula for Key Brands?

Hey Amit;

Thanks for quick response!

Yes the underlined brands are Key but I also want to categorize the rest as others.

Also a brand could be key in one country but not key in another.

Appreciate the help

Kind Regards;

Khalid B

• ###### 3. Re: How can I create formula for Key Brands?

I think you just need a series of IF statements in a calculated field..

IF [Country] = "China" and [Brand] = "Brand AB" then "Key"

ELSEIF [Country] = "China" and [Brand] = "BRAND AA" then "Key"

........

........

.......

ELSE "Other"

1 of 1 people found this helpful
• ###### 4. Re: How can I create formula for Key Brands?

It worked!

Thanks Tom