Pivot table showing zeros

Allie Forbes
Allie Forbes ✭✭✭
edited 06/14/22 in Add Ons and Integrations

I have three locations and different tasks associated with each location. I would like to set up a pivot table that shows me the average status of every task at each location. I set up a column that is using a formula to convert the progress bar status into a numerical value that I am trying to use in my pivot table. Can anyone tell me why my averages are coming out to zero?

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    @Allie Forbes There's the problem. When you use quotes around a number, it actually produces a text value. To produce a numerical value, remove the quotes from around the numbers.

    =IF([% Complete]1 = "Empty", 0, IF([% Complete]1 = "Quarter", 0.25, IF([% Complete]1 = "Half", 0.5, IF([% Complete]1 = "Three Quarter", 0.75, IF([% Complete]1 = "Full", 1)))))