Bex nested If condition

[former_member209202]

Hi All,
Although I looked into several thread, but could not make out what is going wrong.

My requirment is based on two columns as below.

1) If Column1 is 0 and column2 is greater than 0 show 100

2) If Column1 is greater than 0 and Column2 0 then -100

3) Formula

I have written the formula as below--

(Column1 == 0.00 AND Column2 > 0.00)*100+(Column1> 0.00 AND Column2 == 0.00)*(-100)+(Formula)

But it is not giveing me the desired out put in second case where it is becoming -101.

Any quick help is really appreciated.

Regards
Sourav

[Former Member · Accepted solution]

Hi Sourav,

Please use below formula

(Column1 == 0.00 AND Column2 > 0.00)*100+(Column1> 0.00 AND Column2 == 0.00)*(-100)+(Column1 <> 0.00 OR Column2 <= 0.00)*(Column1<= 0.00 OR Column2 <> 0.00)*(Formula)