Splunk Search

Why are there sum issues in splunk table?

ositaumeozulu
Explorer

splunk table not giving the accurate sum of the fields in addtotals, even when i use the stats sum function, once the nos exceed 100000, it will not sum itinnacurate result in the addtotalsinnacurate result in the addtotals

Labels (1)
0 Karma

duncangoff3
Splunk Employee
Splunk Employee

it would be a little easier to help if you included the search you used, but from what i can see its because you have a mix of number and text strings. 1234 is a number 1,234 is a string, its adding the numbers and skipping the strings.

to fix you need to either;

 

a. do your sums before adding commas

or 

b. convert you strings to numbers before doing the math
ie | eval numbers=tostring(<string_field>,"commas") | stats sum(numbers)
tonumber(<str>, <base>) .

 

Feel free to reply with your original search if you need any further help.

0 Karma

ositaumeozulu
Explorer

Wow, many thanks @duncangoff3 you are awesome

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud’s AI Assistant in Action Series: Analyzing and ...

This is the second post in our Splunk Observability Cloud’s AI Assistant in Action series, in which we look at ...

Elevate Your Organization with Splunk’s Next Platform Evolution

 Thursday, July 10, 2025  |  11AM PDT / 2PM EDT Whether you're managing complex deployments or looking to ...

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...