Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

HELP

Highlighted
7 - Meteor

Can some check and see what is wrong with this formula?

 

if [Entity Code+Entity Name] = [Right_Entity Code+Entity Name] AND
[Account Code] = [Right_Account Code] THEN
[Methodology] Else
0 ENDIF

 

Thanks

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @imrahu01 

 

What message are you seeing when you try to run this?


Could you take a screenshot from the configuration of the Formula Tool?

 

Cheers,

Highlighted
10 - Fireball

It would be easier to check if you could upload the workflow or a sample of it.

 

But from the looks of it it could be one of a few things:

1: Methodology is a string and your ELSE results in number

2: you have an issue where your Entity Code + Name fields or Account Codes are different field types.

 

The structure of your IF ELSE statement is fine.

 

IF 

        [Entity Code+Entity Name] = [Right_Entity Code+Entity Name]

        AND

        [Account Code] = [Right_Account Code]

THEN [Methodology]

Else 0

ENDIF

Highlighted
7 - Meteor

Hi @Thableaus ,

Thanks for your reply. @MichaelLaRose's solution worked for me. Thanks.

Labels