Null Handling

[#1]

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

[#2]

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.

[sasiparupudi1]

Sorry,

if( (([False Alert] <> 'Auto Approved') or len([False Alert])=0),'OK','CANCEL') as AACTION

[Anonymous]

Hi,

Might be it din't recogonise it as null, try this

=if(FalseAlerts = '','Unknown',if(FalseAlerts<>'Auto Approved','OK','CANCEL'))

Regards,

Sindu

[Anonymous]

Hi,

maybe is better if we can have sample data because it can be a guessing game.

Best regards.

[sasiparupudi1]

Hi

Did you get your answer?

Sasi

[avinashelite]

try like :

if(Len(Trim(FalseAlerts))< = 0 or FalseAlerts='Auto Approved','OK','CANCEL')