Percent Problem

[Anil_Babu_Samineni]

Hello,

PFA of my image. Here i want to see percentage. If syntax looking like bad then use the Variable, Please

My Expression is

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

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

/

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

- Anil

[#2]

Hi Anil could you please share your data ?

[Anonymous]

Hi Anil,

Are <50, 50-70, >70 values of your dimension.

Share sample data.

[Anil_Babu_Samineni]

PFA

[#5]

try this one

chart properties ->expression tab->click the check box relative

[Anil_Babu_Samineni]

Hari,

The problem is expression, if we check that it will showing different.

[Anil_Babu_Samineni · Accepted solution]

Hello,

I got the solution. Can you please let me know how to use that variable into expression.

Might be you all will help me about second task.

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

I am expecting something like below.

$(2014_Variable)

/

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

- Anil