Conditional Statement with multiple conditions

[alijalil]

Hello Im trying to build a multi-conditional statement  as follows

If([Category]="medicine" and [CountNonNull_Birth_Country]= "5", then "Yes", else "No" endif . For some reason, I get malformed IF statement error at "5". Attached table snapshot below. Thanks in advance! 

[ShankerV]

@alijalil 

It is because the column CountNonNull_Birth_COuntry will be INT 

Hence when you do the check under "5" double quotes, it is for string.

Many thanks

Shanker V

[ShankerV]

@alijalil 

INT - I try to refer as Interger/Numeric

[messi007 · Accepted solution]

@alijalil,

Please try the formula below :

If ([Category]="medicine" and [CountNonNull_Birth_Country]= 5)  then "Yes" else "No" endif 

I think you forgot to close parenthesis and CountNonNull type is double that's way I deleted the quotation marks.

Hope this helps!

Regards

[binuacs]

@alijalil You need to update your IF Else Formula

[ShankerV]

@alijalil 

Please find the sample output for your issue

Many thanks

Shanker V

[Raj]

If([Category]="medicine" and [CountNonNull_Birth_Country]= 5  then "Yes", else "No" endif 

try this (insert a select tool to convert nonull to int16 if not)

 

[alijalil]

@messi007 Thanks, this worked!

[alijalil]

Thank you all for the responses.

One more thing - do we know where we can get the sample solutions for the practical questions from the Core certification assessment?