Hi troyward,
Thanks for your reply. Yes, that is correct.
| eval Change = if(change < 0.001, 0.001, if (change > 0.1, 0.1, change))
works perfect for the "Change" field.
I need it to apply to 3 total fields. If one doesn't match, then result should not show.
How do I do an eval on 3 different fields?
Perhaps...
| eval Change = if(change < 0.001, 0.001, if (change > 0.1, 0.1, change)), Volume = if(Volume < 0.002, 0.002, if (Volume > 1.0, 1.0, Volume)), Price = if(Price < 1.0, 1.0, if (Price > 0.001, 0.001, Price))
Or can you not simply comma separate the different fields for eval?
Thanks!
... View more