Currently I can use a write an if statement in the following form:
...
| eval adjusted_start=start_sum + 1
| eval counter=if(adjusted_start=2,111,555)
where start_sum is a field with a value of either 1 or 2.
However, is there a way to simplify these two lines into one line? I thought the following would work (nesting the eval into the if statement), but either my syntax is off or you can't do it this way.
| eval counter=if(eval(start_sum+1)=2,111,555)
Thanks!
You should be able to do math logic inline:
| eval counter=if(start_sum+1=2,111,555)
You should be able to do math logic inline:
| eval counter=if(start_sum+1=2,111,555)