Splunk Search

How to sum two numeric fields resulting in a concatenation of the two fields?

patouellet
Path Finder

Hello Splunk Ninjas,

First time I've seen this: I have two fields, clearly regognised as numeric fields by Splunk. They are named:
"Put Count"
"Put1 Count"

I want to sum these fields, so I do this:

eval Put_Count_Sum= "Put Count" + "Put1 Count"

But instead of Put_Count_Sum being the sum of both fields, Put_Count_Sum is equal to the text string: "Put CountPut1 Count"

I understand it might have something to do with my fields having spaces, but not sure how to work around that.

Thank you.

0 Karma
1 Solution

horsefez
Motivator

Hi @patouellet,

try using
eval Put_Count_Sum= 'Put Count' + 'Put1 Count'

View solution in original post

horsefez
Motivator

Hi @patouellet,

try using
eval Put_Count_Sum= 'Put Count' + 'Put1 Count'

patouellet
Path Finder

Thank you works perfectly.

0 Karma
Get Updates on the Splunk Community!

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

🔐 Trust at Every Hop: How mTLS in Splunk Enterprise 10.0 Makes Security Simpler

From Idea to Implementation: Why Splunk Built mTLS into Splunk Enterprise 10.0  mTLS wasn’t just a checkbox ...