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

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

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

Found a reply


"fabre jerome" wrote:

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

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

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

=IF(divisor,A1/divisor,A1)

Regards,
Peter T

"fabre jerome" <fabre wrote in message
...
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