Instead of Zero pivot sum option is returning to the value -4.54747350886464E-13

R

Rajani krishnappa

New member
Joined
Mar 28, 2018
Messages
1
Reaction score
0
Points
0
Hi All,

In the pivot table when i was using sum option for consolidating data, positive & negative values are getting nullified, instead of reflecting as Zero am getting the error as -4.54747350886464E-13.

Please help to resolve this on urgent basis, plzzzzzzzzzzzzzzzzz help :(

Enclosed working file.



regards,
Rajani
 

Attachments

  • Forum querry.xlsx
    11.8 KB · Views: 18
CROSS POST

This question has been posted in at least one other forum.
Do not post any further responses in this thread until a link has been provided to these cross posts.

Whilst we would rather you didn't cross-post, we know that there may be a valid reason for doing so. All we ask is that you provide the links in your original post to your question in the other forum(s). Read this to understand why: https://www.excelguru.ca/content.php?184

This forum is full of volunteers that give up their own time to help others, something that should be respected and not taken for granted. It’s never nice for someone to find out that a problem they have spent time solving for you has already been answered somewhere else without them knowing, and so we ask you to make it clear that you have also asked elsewhere.
Please update your original post to include the link(s).

From <https://www.excelguru.ca/forums/sho...auto-populate-neighbor-cell&p=33278#post33278>
 
Hey AliGW,

No doubt, i respect all the members who takes out their valuable time to answer & solve the queries which gets posted in the forum.

Yeah this post is cross post in similar forum, as i was hurry to get resolved my issue & nothing to hide or disrespect someone.

"Please update your original post to include the link(s)." -Please help me on this


regards,
Kushi
 
I don't need to help you - just copy and paste the link from the address bar.

How much of a hurry you are in is irrelevant. The rules are for all of us, regardless.

Why are you using two different accounts here?
 
You must log in or register to reply here.
Back
Top