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!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...