NancyRG
New Member
- Joined
- Mar 10, 2015
- Messages
- 3
I have read and incorporated several solutions for this problem(I have Excel 2010).
Currently, my formula in the calculated field of my Pivot table is (=IF('OptIn Info'/'Leads Info'=0,"-",'OptIn Info'/'Leads Info'). Both the OptIn and Lead numbers can have 0's creating the error.
I have also taken out the "0's" from my data, that doesn't work.
I have tried ISERROR and that doesn't work. Screws up all calculations
In Pivot Table Options I have changed the format for error values to show "None", and empty cells to have --. This has helped clean up the Pivot table.
BUT My Sub Totals for YTD and Grand Totals do not work if there is an error and says "None" like I've told it to do, it will not Calculate. It does work at a month level? and it shows totals for the OptIn & Leads that it should be dividing.
Is there another solution? (P.S. I can't figure out how to paste screen shot or attach sample) HELP!!
Currently, my formula in the calculated field of my Pivot table is (=IF('OptIn Info'/'Leads Info'=0,"-",'OptIn Info'/'Leads Info'). Both the OptIn and Lead numbers can have 0's creating the error.
I have also taken out the "0's" from my data, that doesn't work.
I have tried ISERROR and that doesn't work. Screws up all calculations
In Pivot Table Options I have changed the format for error values to show "None", and empty cells to have --. This has helped clean up the Pivot table.
BUT My Sub Totals for YTD and Grand Totals do not work if there is an error and says "None" like I've told it to do, it will not Calculate. It does work at a month level? and it shows totals for the OptIn & Leads that it should be dividing.
Is there another solution? (P.S. I can't figure out how to paste screen shot or attach sample) HELP!!