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 |