5 Replies Latest reply on Nov 8, 2013 1:47 AM by santhosh krishnan

# #Newbie : How to I created a calculated % field?

For example I have a field called "Country" which has the list of all countries. I want to create a field called %Country which would give the % of each country (i.e Sum of records of that particulat country/ sum of records of all country together)

• ###### 1. Re: #Newbie : How to I created a calculated % field?

Hi Santhosh,

You can check the following link - Percentage Options

You can also do this by:-

Hope this helps !

Warm Regards,

Prashant Sharma - India | LinkedIn

1 of 1 people found this helpful
• ###### 2. Re: #Newbie : How to I created a calculated % field?

Hi Santhosh,

The simpler way is to drag Country to Rows shelf and the measure Number of Records to the Mark Text

Then click on menu Analysis and select the option Percent of > Table

This will convert the number of record in % of records per Country respect to total Number of Records.

There is other way, using a table calculation. In this case you need to create a calculated field, for instance Percent of records with the formula:

```SUM([Number of Records]) / TOTAL(SUM([Number of Records]))
```

Create a new worksheet, drag Country to Rows shelf and the calculated field Percent of records to the mark Text. The values on percent of records are fractions of 1, so it is required to change the format of green pill on Mark text to Percentage. You are able to change this by clicking on green pill Percent of records, select Format and change Numbers to percentage.

See attached workbook as a demonstration. Note that I use States instead of Country in the workbook with sample data.

Best regards,

Ramon.

• ###### 3. Re: #Newbie : How to I created a calculated % field?

Thank you Ramon - This is exactly what I wanted to know!

Thank you Prasanth - this is neat stuff!

• ###### 4. Re: #Newbie : How to I created a calculated % field?

Hi Santhosh,

I'm glad you get what you wanted to know