| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Calculated Field - Sum/count
I have a pivot table that returns data from a SQL View.
The pivot table counts the total number of incedents, and sums a SLA met field. The SQL table returns a 1 if the SLA was met, or a 0 of it was not. Why, when I try to get the percentage (sum of SLA / count of incedents) using a calculated field does every row return a div/0 error? Thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Calculated Field - Sum/count
0/0 will give you the #DIV/0 error. Try =IFERROR(0,SLA/count)
-- Kevin "Jeff Metcalf" wrote: I have a pivot table that returns data from a SQL View. The pivot table counts the total number of incedents, and sums a SLA met field. The SQL table returns a 1 if the SLA was met, or a 0 of it was not. Why, when I try to get the percentage (sum of SLA / count of incedents) using a calculated field does every row return a div/0 error? Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Calculated Field in a Pivot Table for same field | Excel Discussion (Misc queries) | |||
| Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| Calculated Field in Pivot Table | Excel Worksheet Functions | |||
Linear Mode
