D
dylankrapf
I have been killing myself with this problem for 2 days now, and I giv
up. I can't solve this myself. It seems that Excel works differentl
each time I use it. This is my situation:
I have a .csv file w/ 20k records.
I have a pivot table report that reads the .csv as the source.
In the pivot, I need calculate the average for one of the columns i
the .csv
The problem is that 90% of the records have a 0 as the value for tha
column.
I dont want to average the 0's into the average.
When I take out the zeros, i get a #DIV/0 error.
I have successfully been able to make this calculation twice, but i
seems very inconsistent, as if Excel were working differently each tim
I do it. Can someone provide some insight on this??
There has to be an easy way of doing this.... I appreciate the help..
up. I can't solve this myself. It seems that Excel works differentl
each time I use it. This is my situation:
I have a .csv file w/ 20k records.
I have a pivot table report that reads the .csv as the source.
In the pivot, I need calculate the average for one of the columns i
the .csv
The problem is that 90% of the records have a 0 as the value for tha
column.
I dont want to average the 0's into the average.
When I take out the zeros, i get a #DIV/0 error.
I have successfully been able to make this calculation twice, but i
seems very inconsistent, as if Excel were working differently each tim
I do it. Can someone provide some insight on this??
There has to be an easy way of doing this.... I appreciate the help..