Splunk Search

Wrong results on stats sum or addcoltotals upon reaching 13th decimal value and beyond

rajyah
Communicator

Hi,

The screenshot presented below shows that there are 2 pairs that negates each other which should equal to 0 on column1, same with column2. With that in mind, the total value should be 0, right? But upon rounding it up to 13th decimal value and beyond, it no longer equates to 0.

Negative.PNG

 

 

I've attached a search query that will replicate the said issue stated above.

 

 

 

| makeresults
| eval column1=600.0000
| append
    [| makeresults
    | eval column1=390.0000]
| append
    [| makeresults
    | eval column1=355.0000]
| append
    [| makeresults
    | eval column1=575.0000]
| append
    [| makeresults
    | eval column1=355.0000]
| append
    [| makeresults
    | eval column1=590.0000]
| append
    [| makeresults
    | eval column1=600.0000]
| append
    [| makeresults
    | eval column1=355.0000]
| append
    [| makeresults
    | eval column1=-600.0000]
| append
    [| makeresults
    | eval column1=-590.0000]
| append
    [| makeresults
    | eval column1=-355.0000]
| append
    [| makeresults
    | eval column1=-575.0000]
| append
    [| makeresults
    | eval column1=-355.0000]
| append
    [| makeresults
    | eval column1=-390.0000]
| append
    [| makeresults
    | eval column1=-600.0000]
| append
    [| makeresults
    | eval column1=-355.0000]
| eval column2=round(column1/1.12,20) , column1=round(column1,20)
| addcoltotals

 

 

Thank you.

 

Regards,

Raj

Labels (1)
0 Karma

FrankVl
Ultra Champion

My first guess would be that this is the magic of floating point numbers at work. If you're having real life issues like the example you shared, you might want to look at using the sigfig() function: https://docs.splunk.com/Documentation/Splunk/8.0.5/SearchReference/MathematicalFunctions#sigfig.28X....

0 Karma

rajyah
Communicator

So it seems it's really a 'magical'  number then. Thank you sir for your reply.

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...