Skip to Content
0
Former Member
Jan 14, 2011 at 05:05 AM

Nested If Else Statement in BEx

563 Views

Hi All,

I have the following scenario.

I need to write if-else statements for the following :

if( var% >100 AND var>10000000 ) then display 1

else (if var% > 25 then display 2, else display 3 )

I wrote the following :

(var% > 100 AND var>10000000)1 + (NOT(var%>25)2 + (var%=< 25)*3 )

But it does not work for all cases.

Can someone please suggest a better way to write the same.

thanks in advance.

Regards,

Rohit