|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 10th, 2009, 12:32 PM
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
November 10th, 2009, 03:31 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
