| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculation field in a Pivot Table | Excel Discussion (Misc queries) | |||
| Using Subtotal field of a pivot table in a calculation | Excel Discussion (Misc queries) | |||
| remove a calculated field from a pivot table in Excel 2003 | Excel Discussion (Misc queries) | |||
| Remove outdated checkboxes from Excel Pivot Table field pulldown? | Excel Discussion (Misc queries) | |||
| Pivot Table: Remove old field cell value | Excel Discussion (Misc queries) | |||
Linear Mode
