| eval hours= if (day="Monday", hours=(a+b), hours)
So basically if day=monday, i wants hours to add up a+b
hello, what are you trying to achieve?
Could you please give us input and expected output in tabular format.
Isn't it should be
| eval hours=if(day="Mon",hours+2,hours)
hello, what are you trying to achieve?
Could you please give us input and expected output in tabular format.
Isn't it should be
| eval hours=if(day="Mon",hours+2,hours)
Nevermind you solved . Thank you so much
Table
hours day hours2 hours3
null monday 2 5
8 tuesday null null
8 wednesday null null
8 thursday null null
8 friday null null
If day = monday i want hours to be 2+5