HELP

[imrahu01]

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

[Thableaus · Accepted solution]

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,

[MichaelLaRose · Accepted solution]

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

[imrahu01]

Hi @Thableaus ,

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