Hi Guys,
I am trying to insert a calculated field in my pivot table that should divide the sum of numbers from column D based on the value in column E by the sum of numbers from column D based on a different value in column E. I am using this formula
But this gives me an error and the new field is showing #DIV/0!
How can I fix this?
Any help in fixing the formula or pointing to another solution will be much appreciated.
Thanks
Asad
I am trying to insert a calculated field in my pivot table that should divide the sum of numbers from column D based on the value in column E by the sum of numbers from column D based on a different value in column E. I am using this formula
Rich (BB code):
=SUM(IF('Route/Headless'="General Route",'Touch Ons',0))/SUM(IF('Route/Headless'="Headless",'Touch Ons',0))
But this gives me an error and the new field is showing #DIV/0!
How can I fix this?
Any help in fixing the formula or pointing to another solution will be much appreciated.
Thanks
Asad