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 ,
In this case in script level u can replace null with some character.
like this
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')
Thanks,
Ashok.
Sorry,
if( (([False Alert] <> 'Auto Approved') or len([False Alert])=0),'OK','CANCEL') as AACTION
Hi,
Might be it din't recogonise it as null, try this
=if(FalseAlerts = '','Unknown',if(FalseAlerts<>'Auto Approved','OK','CANCEL'))
Regards,
Sindu
Hi,
maybe is better if we can have sample data because it can be a guessing game.
Best regards.
Hi
Did you get your answer?
Sasi
try like :
if(Len(Trim(FalseAlerts))< = 0 or FalseAlerts='Auto Approved','OK','CANCEL')