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