script logic if condition

[Former Member]

Dear All,

I've got a quick question.

I need to put in my script logic the following condition

if %value% is between 0-5000 it is %value% * 2

elseif %value% is between 5001-7000 the result is %value *3

else %value% *4

*REC(EXPRESSION = ( 0 < %VALUE% < 5000) ? %VALUE% * 2 : 0)

  *REC(EXPRESSION = ( 5001 <= %VALUE% < 7000) ? %VALUE% * 3 : 0 )

  *REC(EXPRESSION = ( %VALUE% >= 7000) ? %VALUE% * 4 : 0 )

this is delivering acumulated values if I put 8000 as %VALUE (and it is wrong)

any tips?

thanks

[former_member186338 · Accepted solution]

If you have JavaScript calculation engine the correct syntax will be:

*REC(EXPRESSION=(%VALUE%>0)? ((%VALUE%<5000)? %VALUE%*2 : 0) : 0)

*REC(EXPRESSION=(%VALUE%>5000)? ((%VALUE%<7000)? %VALUE%*2 : 0) : 0)

...

[former_member186338]

Where have you seen this syntax???

0 < %VALUE% < 5000