Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Logical AND operator not giving me correct result for Dynamic Value

Avatar

Level 1

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.

6 Replies

Avatar

Community Advisor

@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!

Avatar

Level 1

@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

 

 

pawan_maurya_0-1638389330323.png

 

 

pawan_maurya_1-1638389374603.png

Thanks

 

Avatar

Community Advisor

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

SatheeskannaK_0-1638392790147.png

 

Avatar

Level 1

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

Avatar

Community Advisor

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

Avatar

Administrator

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!