Level 1

0% to

Level 2

Tip /

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

View all

## Logical AND operator not giving me correct result for Dynamic Value

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

6 Replies

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.

Thanks!

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

Thanks

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

Level 1

Can You please show me what you have tried..

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