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=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

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Calculated Field in Pivot Table to calculate percentage from same column in table

Thread starter asad
Start date Jul 17, 2020

asad

Well-known Member

Jul 17, 2020

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

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