Aug 01 2019 09:35 AM
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!.
Aug 01 2019 01:40 PM
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.
Aug 01 2019 01:53 PM
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.
Aug 01 2019 02:40 PM
@CarlW can you post a small data sample? You can attach a workbook. Just make sure to replace confidential data with fake data.