if condition

[#1]

Hello guys,

how to make this condition using if..else :

profit range between 1000 to 2000 then status is : acceptable.

profit range between 2000 to 3000 then status is : above average.

profit range between 3000 to 4000 then status is : exceeds expectation.

thanks

[rajeshvaswani77]

if((prange>=1000 and prange<=2000), 'acceptable',if((prange>2000 and prange<=3000),'above average',if((prange>3000 and prange<=4000),'exceeds expectation','NA')))

[jagan]

Hi,

Use this expression

If (profitRange > 3000 AND profitRange <= 4000, 'exceeds expectation',

     If (profitRange > 2000 AND profitRange <= 3000, 'above average',

     If (profitRange > 1000 AND profitRange <= 2000, 'acceptable', 'N/A')))

Regards,

Jagan.

[CELAMBARASAN]

Hi,

     I think this expression is enough for you.

If (profitRange > 3000, 'exceeds expectation',

     If (profitRange > 2000 , 'above average',

     If (profitRange > 1000, 'acceptable', 'N/A'))) [as FieldName] use this alias part if your using it in load script.

Celambarasan