Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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
False Alerts:
AUTO APPROVED
APPROVED
REJECTED
It works for AutoApproved , Approved and Rejected. Not working for the blank one
Hi,
what do you mean with not work.
Waht happen when the False Alert is Blank/Null and what do you expect in this case?
Regards.
AACTION should reflect as OK
Hi,
This should work
=if(IsNull(FalseAlerts),'Unknown',if(FalseAlerts <> 'Auto Approved', 'OK','CANCEL'))
So,
maybe is ggod this:
=if(IsNull(FalseAlerts),'',if(FalseAlerts<>'Auto Approved','OK','CANCEL'))
Reagrds.
Hi
Its Not working
Should be
=if(if(IsNull(FalseAlerts),'Unknown', FalseAlerts) <> 'Auto Approved', 'OK','CANCEL')
I.e. replace the NULL value with 'Unknown' and then compare to 'Auto Approved'
Sorry,
try this:
=if(IsNull(FalseAlerts),'Missing',if(FalseAlerts)<>'Auto Approved'),'OK','CANCEL'))
Please try
if( (([False Alert] <> 'Auto Approved') or len([False Alert])>0),'OK','CANCEL') as AACTION,
Hi
Try like this
=if(Len(Trim(FalseAlerts)) = 0,'UnKnown ',if(FalseAlerts<>'Auto Approved','OK','CANCEL'))