Forum Discussion

CarlW's avatar
CarlW
Copper Contributor
Aug 01, 2019

Calculated Field for Pivot Table - Unable to Calculate

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!.

excel

3 Replies

  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    MVP
    Aug 01, 2019

    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.

     

    • CarlW's avatar
      CarlW
      Copper Contributor
      Aug 01, 2019

      Thanks for the quick response IngeborgHawighorst 

       

      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.

       

      • IngeborgHawighorst's avatar
        IngeborgHawighorst
        MVP
        Aug 01, 2019

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

Resources