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
Solved! Go to 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,
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
Hi @Thableaus ,
Thanks for your reply. @MichaelLaRose's solution worked for me. Thanks.