Splunk Search

## Why Splunk is telling me that my eval expression is malformed?

Explorer

I'm trying to evaluate the normal distribuiton's PDF into my search as follows:

`... | eval prob=(1/sqrt(2*pi()*sigma^2))*exp(-((x-mi)^2)/(2*sigma^2))`

And I'm getting this error message:

Error in 'eval' command: The expression is malformed. Expected ).

What am I doing wrong? I tested the expression on Excel and it works fine...

Tags (2)
1 Solution
Legend

I haven't tested this, but at first glance, it could be because of the the power of function. Change all occurences of `sigma^2` to `pow(sigma, 2)`. So your formula s/b written like this

``````(1/sqrt(2*pi()*pow(sigma,2)))*exp(-(pow((x-mi),2))/(2*pow(sigma, 2)))
``````
Legend

I haven't tested this, but at first glance, it could be because of the the power of function. Change all occurences of `sigma^2` to `pow(sigma, 2)`. So your formula s/b written like this

``````(1/sqrt(2*pi()*pow(sigma,2)))*exp(-(pow((x-mi),2))/(2*pow(sigma, 2)))
``````
Explorer

Thank you!

Get Updates on the Splunk Community!

#### Enterprise Security Content Update (ESCU) v3.54.0

The Splunk Threat Research Team (STRT) recently released Enterprise Security Content Update (ESCU) v3.54.0 and ...

#### Using Machine Learning for Hunting Security Threats

WATCH NOW Seeing the exponential hike in global cyber threat spectrum, organizations are now striving more for ...

#### New Learning Videos on Topics Most Requested by You! Plus This Month’s New Splunk ...

Splunk Lantern is a customer success center that provides advice from Splunk experts on valuable data ...