Forum

E numbers in Pivot ...
 
Notifications
Clear all

E numbers in Pivot Table

8 Posts
5 Users
0 Reactions
458 Views
(@kasey)
Posts: 20
Eminent Member
Topic starter
 

Hi

Looking for advice and help with Pivot table, I have several values that should be 0 (zero) but instead they are E numbers (for example -2.1316282072803E-14), and so I cannot filter them out as not a true Zero. 

 

The values are ....

-98.355
37.148
44.085
-17.123
-34.245
68.49
-7.955
-44.672
44.672
-71.596
65.326
-42.676
43.302
-13.599
-27.19
-54.389
108.777

 

Grateful for any advice. Thank you!

Kasey

 
Posted : 07/04/2022 8:31 am
Anders Sehlstedt
(@sehlsan)
Posts: 971
Prominent Member
 

Hello,

Without a sample file we can't look for any errors, I mean, if the expected result is 0 and you get those numbers, then there must be some calculation errors.

Br,
Anders

 
Posted : 07/04/2022 2:31 pm
(@kasey)
Posts: 20
Eminent Member
Topic starter
 

Hi Anders,

Please see attached sample file.

 

Thanks for any help you may give

Thanks

 
Posted : 08/04/2022 4:34 am
Alan Sidman
(@alansidman)
Posts: 223
Member Moderator
 

Right click on the value in your PT and select Format.  Change the format from General to Number.

Screenshot-2022-04-07-090538.jpg

 
Posted : 08/04/2022 11:07 am
(@kasey)
Posts: 20
Eminent Member
Topic starter
 

As I stated in the file Alan, merely changing the number format does not help.

 
Posted : 09/04/2022 4:59 am
Riny van Eekelen
(@riny)
Posts: 1195
Member Moderator
Alan Sidman
(@alansidman)
Posts: 223
Member Moderator
 

As I stated in the file Alan, merely changing the number format does not help.

Interesting because when I did the reformatting it came up as zero for me.

Alan

 
Posted : 09/04/2022 6:42 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Kasey,

Posting in multiple forums is against all forum rules, including ours. You must declare cross posting so we know not to waste time on questions that are already answered. 

Mynda

 
Posted : 09/04/2022 9:11 pm
Share: