Set Analysts Exclude problem

[Anil_Babu_Samineni]

Hello,

I want to exclude two values, Unfortunately, The pop up coming only exclude values.

Help me Please

=If((Avg({<[2014 name] = {*}-{'Key Message Delivery','Sales Objective Category'}>} [2014 Score])) >=70,RGB(255,0,0),

  if((Avg({<[2014 name] = {*}-{'Key Message Delivery','Sales Objective Category'}>} [2014 Score])) <70 and (Avg({<[2014 name] = {*}-{'Key Message Delivery','Sales Objective Category'}>} [2014 Score])) >50 ,RGB(0,255,0),

  if((Avg({<[2014 name] = {*}-{'Key Message Delivery','Sales Objective Category'}>} [2014 Score])) <=50 ,RGB(255, 165, 0)

  )

  )

)

[Anil_Babu_Samineni]

In my real, I am using same unfortunately my client told me this is wrong, Just think and how and why?

- Anil

[Anil_Babu_Samineni]

How about this,

Avg({$<[2014 rep] = {"=[2014 name] =- {'Key Message Delivery','Sales Objective Category'}"}>} [2014 Score])

Here, I want to share my logic

I want to know average score which based at 2014 rep values and then meantime, I want to exclude those two values.

It showing No data to display

Please help me.