Conditional Statement with multiple conditions

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!

Workflow

Expression

Accepted answers

messi007

@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

All comments

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

@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

binu_acs

@alijalil You need to update your IF Else Formula

IF_Condition_1118.yxmd

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)

Annotation 2022-11-18 140235.png

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?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703