If condition

[TanyaS]

Hi, i have two fields named as Blank and Expired_lastmonth. I am writing this piece of code, but it is throwing an error, can someone help me out?

If(Blank='Expired' or Expired_lastmonth='Expired', 'Exp', 'No') as total_exp_rev. 

(As a result of the above code, the total_exp_rev has the values where blank is expired, but not for the Expired_lastmonth field)

[anat]

Can you share the sample data how it looks.. 

[Vegar]

Could it be something wrong with the second condition? I would have check if this expression returns any values.

If( Expired_lastmonth='Expired', 'Exp', 'No') as total_exp_rev,