ignore zero values within a formula

[nparsons75]

Hi, I have a table containing data. Column BK contains a long list of values (percentages). I have a pivot table that shows an average of these values. Some values are zero. I need the pivot table to ignore and value that is zero, is this possible?

 

[Special-K99]

Use AVERAGEIF() with "<>0"

 

[nparsons75]

Hi, where would I add the formula, it's the pivot table causing the problem. Thank you.