I have been unable to add two field values and use the new value of a new column
I'm trying to take one field, multiply it by .60 then add that to another field that has been multiplied by .40. This is how I thought it would be created:
eval NewValue=(FirstValue*.60)+(SecondValue*.40)
I've verified that: | stats values(FirstValue) | and | stats values(SecondValue) | print out expected results
I've also verified that I am able to do |eval NewValue1=(FirstValue*.60) | and | eval NewValue2=(SecondValue*.60) | both yielding results. However, when I try: | eval NewValue=(FirstValue+SecondValue) I get nothing.
Any ideas/thoughts?
... View more