
Kasey Morris
Member
Members

Forum Posts: 6
Member Since:
April 6, 2022
April 6, 2022

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

Anders Sehlstedt
Eskilstuna, Sweden
VIP
Members

Trusted Members

Trusted Members

Forum Posts: 871
Member Since:
December 7, 2016
December 7, 2016


Alan Sidman
Steamboat Springs, CO
Member
Members

Trusted Members

Trusted Members

Forum Posts: 132
Member Since:
October 18, 2018
October 18, 2018


Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members

Trusted Members
Moderators
Power BI

Trusted Members
Moderators
Power BI

Forum Posts: 441
Member Since:
January 31, 2022
January 31, 2022

Didn't you get your answer here?

Alan Sidman
Steamboat Springs, CO
Member
Members

Trusted Members

Trusted Members

Forum Posts: 132
Member Since:
October 18, 2018
October 18, 2018


Mynda Treacy
Admin

Forum Posts: 4449
Member Since:
July 16, 2010
July 16, 2010

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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Richard West, Rocco Pinneri, Alexandra Radu, AndyC
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Raj Mattoo
Mark Luke
terimeri dooriyan
Jack Aston
AndyC
Denise Lloyd
michael serna
mashal sana
Tiffany Kang
Leah Gillmore
Forum Stats:
Groups: 3
Forums: 24
Topics: 6219
Posts: 27276
Member Stats:
Guest Posters: 49
Members: 31903
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
