Problem with the If condition

[#1]

Hi All,

I have this if condition, but it's not working for some reason. Can anyone tell me what am I missing here?

Load if((Country = 'United States of America' or Country ='China' or Country ='Taiwan' or Country ='Germany (Federal Republic of)' or Country ='Netherlands') and ( "Status"= 'Allowed' or "Status"='Granted')

and( Company = 'ABC')

and  (DFAnalysis = 'Low')

AND  (IFSCORE >= 3), 'LOW', 'NA')  as Stage,   ID

Resident Temp;

Thank you.

[#2]

hi,

write the last condition as " and Company='Apple'

                                        and IFSCORE >=3

                                        and  wildmatch( Tag, '*Rejected*')=0 

                                        and  DFAnalysis='LOW' "

incooperate this code in if condition,this is working.

else please attach your application so i can work on it.

Pratibha