Calculated Field for Pivot Table - Unable to Calculate

[CarlW]

I have two values shown in my pivot table per department, Count of People and Sum of People Using Widgets. I want to divide the Sum of People Using Widgets by the Count of People to get a percentage of the people using widgets. Whenever I try to insert a Calculated Field, I get a result of #DIV/0!.

[#2]

Hello @CarlW , 

how do you create the calculated field? In this screenshot, I divide the columns by one another. The #Div/0 error only shows if the people column is zero.

[#3]

Thanks for the quick response @Ingeborg Hawighorst 

I created the formula in the same way. Because the People field is a count of how many people there are, I am wondering if it can't calculate this because the basis for the counts is people's names. It can't do calculations based on the source data.

[#4]

@CarlW  can you post a small data sample? You can attach a workbook. Just make sure to replace confidential data with fake data.