Hello,
I’ve got a large set of date which I’m using a Pivot Table to analyse.
I know that the sum of some of it equates to 0. The Pivot Table also displays 0, yet when I click on the cell and look in the formula bar it says -1.1990778-08 (it goes on many more numbers). There are other 0 figures in this column which do not behave in such manner. I’ve formatted the whole column to display as numbers. I’m at a loss as to why it’s behaving in such way as when I want to apply a further filter to my Pivot Table of 0 items it is being excluded in error.
appreciate any help! Thanks
I’ve got a large set of date which I’m using a Pivot Table to analyse.
I know that the sum of some of it equates to 0. The Pivot Table also displays 0, yet when I click on the cell and look in the formula bar it says -1.1990778-08 (it goes on many more numbers). There are other 0 figures in this column which do not behave in such manner. I’ve formatted the whole column to display as numbers. I’m at a loss as to why it’s behaving in such way as when I want to apply a further filter to my Pivot Table of 0 items it is being excluded in error.
appreciate any help! Thanks