Calculated field (Column A divide by Column B) Value says 0 but both columns are are not 0

**ricomania** · 03-13-2015, 01:27 AM

I used calculated field in pivot table and I was wondering why I get 0 (or #DIV/0 in some cases). Please help!

**Pepe Le Mokko** · 03-13-2015, 03:47 AM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Calculated field (Column A divide by Column B) Value says 0 but both columns are are not 0

LinkBack

Thread Tools

Rate This Thread

Display

Calculated field (Column A divide by Column B) Value says 0 but both columns are are not 0

Re: Calculated field (Column A divide by Column B) Value says 0 but both columns are are n

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Pivot Table Calculated Field - Sum of Column A * Min of Column B

[SOLVED] Referring to a Sub-Field on Calculated Field Pivot Table Column?

Using the 'calculated' function,can I divide an item by a field when using a pivot table?

Can I divide data in my pivot by days in the month using a calculated field?

Calculated Field/Item using the same column header

Bookmarks

Bookmarks

Posting Permissions