# Pivot Table - Calculating percentage of two columns in calculated field

#### dconnors

##### New Member
If someone can direct me to the correct place that would be great. I have Excel 2016. I posted elsewhere without a response so I don't know if that was because there's no answer, I was unclear, or because it was a pretty old post. I also searched posts & a few books with no success.

I'm trying to create a column that shows a percent of "date presented to Client" to "total #" for each employee

I have a count for each column (employee for their total clients, the total client info entered, the total reviewed, and total presented to client.)
I've done ='Date presented to Client'/'Total #' as the formula but end up with #DIV/0!. I want to end up with 3.448% (1/29) and 10.5%(4/38) for the two employees with presentations.

I've tried several things with the same result and my googling skills are apparently pretty poor since I've found nothing on this specifically. Any help or direction would be appreciated.

 Count of Total # Count of Data Loaded Count of Date Reviewed Count of Date presented to Client Count of Field1 36 2 #DIV/0! 26 2 #DIV/0! 13 3 #DIV/0! 29 7 1 1 #DIV/0! 44 6 #DIV/0! 38 7 4 4 #DIV/0!

<tbody>
</tbody>

### Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Replies
1
Views
329
Replies
1
Views
4K
Replies
0
Views
961
Replies
0
Views
394
Replies
6
Views
522

1,191,721
Messages
5,988,303
Members
440,148
Latest member
sandy123

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back