For the Below condition
if([False Alert] <> 'Auto Approved' ,'OK','CANCEL') as AACTION,
The Statement doesnot work when False Alert is Blank.
Following are the list of False Alerts
It works for AutoApproved , Approved and Rejected. Not working for the blank one
In this case in script level u can replace null with some character.
if(isnull(false alert),'Null',false alert) AS False Alert.
so in expression direct we can right ur expression.
if([False Alert] <> 'Auto Approved' ,'OK','CANCEL')