4 Replies Latest reply on Mar 27, 2018 4:16 AM by sudhir ranajn

# Adding % symbol for measures without converting the metric to STRING

Hi Tableau Experts,

I have data in which there are four columns.

1. Customer count

2. Goods count

3. Customer share

4. Goods share

Calculating customer share, I wrote the below calculated field.

Customer count= count(# of customer)

Customer share= count(# of customers) / Total(count(# of customers)) * 100

But the numbers are showing to be 20.34, not 20.34% . I want the numbers for Customer count/Goods count as like 2,000( numbers with comma separated) and for customer share/Goods share as 20.34%(with % symbol).

If I change the number format to percentage, then the whole data get affected. The customer count/Goods count showing like 2,000.00%, 15,456.56% which is inappropriate format. And if I add % symbol in calculated field making whole calculation as a STRING, then I am not able to use the data as continuous.

Regards,

Sudhir

• ###### 1. Re: Adding % symbol for measures without converting the metric to STRING

Hi, Sudhir

You don't have to *100 in your calculation and use format for individual measure as %

ZZ

1 of 1 people found this helpful
• ###### 2. Re: Adding % symbol for measures without converting the metric to STRING

Hi ZZ,

Much appreciated your workaround. But in my scenario I have taken measures as parameter value to form a Bar graph.

When I choose profit and profit ratio from the parameter drop down, the value should be showing in % format (Ex: 20.56%, 23.86% like this) and for other metrics the data should be showing as standard number format with comma separated.

Attaching my sample workbook for your reference and need your help to solve this issue.

Warm Regards,

Sudhir

1 of 1 people found this helpful
• ###### 3. Re: Adding % symbol for measures without converting the metric to STRING

Hi, Sudhir

In this case, I will suggest to use sheet swap through your parameter.

I attached the sample workbook for reference.

Hope this helps

ZZ

1 of 1 people found this helpful
• ###### 4. Re: Adding % symbol for measures without converting the metric to STRING

Hi ZZ,

Thanks for the detailed clarification. It helped me a lot.

Sudhir