hi,

i have a pivot table in which i entered a calculated field. some of the
values have a #DIV/0! so i thought i would try to modify the formula to be
somehting like :

if (iserror('field1'/'field2'),"0",'field1'/'field2'))

but i am getting an error.

what should i do?

thanks in advance,
geebee