![]() |
Calculated Field Total formula not working
i created a calculated firled in my pivot table, but the for the grand total
column it is not calculating. it is calculating in all the other areas, just not the grand total columns. here is what it looks like: as you can see the #DIV/0! , the calculated field formula is Column C = (column A-Column B)/Column B it should state -0.5802 ((Same for Column F=(column D-E)/E) this should be -0.7284) A B C D E F 18752 44671 #DIV/0! 10542 38821 #DIV/0! |
All times are GMT +1. The time now is 02:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com