Logical AND operator not giving me correct result for Dynamic Value

[pawan_maurya]

I'm Trying to figure out greater value figure out greater value from 3 value. But I'm not getting expected result.

I have enrich the data and created three variables  OpenRatioOfA, OpenRatioOfB, OpenRatioOfC.

Values are : 

OpenRatioOfA = 8.70

OpenRatioOfB = 2.00

OpenRatioOfC = 0.00

if I use this below simple condition expression I am getting correct result.

Iif(OpenRatioOfA >= OpenRatioOfB , 'A', 'NEXT') // I got A as ouptput

But whenever I use Logical AND operator it's not giving me correct result

Iif(OpenRatioOfA >= OpenRatioOfB AND OpenRatioOfA >= OpenRatioOfC, 'A', 'NEXT') 

(NOT WORKING)

// Expected Ans = A but getting NEXT

Why this logical AND operator not working in ACS though expression look so simple. Please help me in this. Thanks in advance.

[SatheeskannaK]

@pawan_maurya ,

Are you doing this within delivery template? If so take a look at this documentation on how to use logical operator on expressions vs java script.

https://experienceleague.adobe.com/docs/campaign-standard/using/managing-processes-and-data/filterin...

Thanks!

[pawan_maurya]

@SatheeskannaK  Thanks for your response. I am trying this expression in enrichment activity.

Variables are respectively 

OpenRatioOfA = 8.70

OpenRatioOfB = 2.00

OpenRatioOfC = 0.00

Thanks

[SatheeskannaK]

@pawan_maurya AND operator is correct in this case. I did try with this condition and getting expected result.

[pawan_maurya]

Can You please show me what you have tried..

@SatheeskannaK 

I hope you didnt use static value in the expresion like this

Iif((8.70 >= 2.00) AND (8.70>=0.00), 'A', 'NEXT')

thanks

[SatheeskannaK]

@pawan_maurya Apologize for the late reply. You can see screenshot which i shared earlier. Were you able to resolve the error?

[Sukrity_Wadhwa]

Hi @pawan_maurya,

Were you able to resolve this query with the help of the given solution or do you still need more help here? Do let us know.
Thanks!