Splunk Search

how to calculate sum of two fields using eval command?

Madhan45
Path Finder

I have column A and B, its values are

A- 5,10,15,20
B-1,2,3,4

i need the Total in third field which should contain their addition like below:
Total-6,12,18,24.

how can i use eval command for that.??

Tags (2)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

Are A and B multi-value fields?

---
If this reply helps you, Karma would be appreciated.
0 Karma

woodcock
Esteemed Legend

Like this:

... | eval Total = A + B

Madhan45
Path Finder

for sub,mul,div "A-B", "A*B","A/B" is it so?

0 Karma

woodcock
Esteemed Legend

Exactly, provided that both A and B are single-valued files; is either multi-valued?. Don't forget to click "Accept".

0 Karma
Get Updates on the Splunk Community!

Prove Your Splunk Prowess at .conf25—No Prereqs Required!

Your Next Big Security Credential: No Prerequisites Needed We know you’ve got the skills, and now, earning the ...

Splunk Observability Cloud's AI Assistant in Action Series: Observability as Code

This is the sixth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...