Passing status token to if statement
eval start = strptime('Requested Start', "%d.%m.%Y")|eval end = strptime('Last changed On', "%d.%m.%Y")|eval completed_duration = round((end -start)/86400) |eval other_duration = round((now()-start)/86400)|eval duration_days = if("$Status$" == "Imported Prod" OR "$Status$" == "Withdrawn",completed_duration,other_duration) | table ID,Description,Status,duration_days |fieldformat duration_days = tostring(duration_days) + " Days"
Problem is when if status is passed as * it creates problem and comparison is not correct.. How to solve this? please help?
... View more