how do I remove #DIV/0! in a pivot table calculation field ?

F

fabre jerome

I do formulas in a pivot table, but in my database some fields are empty. So
when I do a calculation in the Pivot Table, the return for some values is
"#DIV/0!".
In the calculated field of the Pivot Table, I do an "if; than; else", but it
doesn't work.
Thanks in advance for your feedback.
Jef
 
P

Peter T

Not sure what you mean by " I do an if; than; else", try

=IF(divisor,A1/divisor,A1)

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Dates In Excel 5
Pivot Table Counting Text Data 0
#DIV?0! in Pivot Table 0
#DIV/0! displayed in Pivot Tables 0
Slicers and Calculated Items in Pivot Table 2
Additional columns for Pivot table 0
Pivot Table Calculated Field - Sum/count 1

Top