Pivot sum option is returning to -4.54747E-13 instead of Zero

[Kushi Krishnappa]

Hi Buddies,

Please help me to resolve the pivot sum option, data is having both the figures of + & - nad net off value will be Zero, but in pivot instead of Zero , value -4.54747E-13 is reflecting.

Attached XL sheet, please help.


regards,
Kushi

 

[GraH - Guido]

Is normal due to 15 floating point precision of Excel (length of number is max 15 digits long). Sometimes very small numbers show up where you would expect 0.

But it seems you have simply formatted it as text and not number.

 

[NARAYANK991]

Hi ,

This is a known problem since Excel uses floating point numbers to represent decimal values.

One solution is to use a calculated field which uses rounding to 2 decimal places.

See the attached file.

Narayan

 

[Luke M]

@Kushi Krishnappa

Thanks for visiting the forums. Note that a polite forum behavior is to notify people when you have posted the same question on multiple sites, known as cross-posting. You have posted this same question here:
https://www.excelguru.ca/forums/sho...s-returning-to-the-value-4-54747350886464E-13

Again, while this is perfectly fine, please remember to include the cross-post link with your post. Thanks.