BEX query with Boolean operation using IF...ELSE.. STATEMENT ?

[Former Member]

Hi,

   Can any one please explain this formula .

   ( stock BT 180 to 365 < 0 )  * ( GR till 180 days >= 0 ) * ( stock BT 180 to 365 + GR till 180 days )

+ ( stock BT  180 to 365 >= 0 ) * ( GR till 180days >= 0 ) * GR till 180 days

+ ( stock BT 180 to 365 < 0 )   * ( GR till 180 days < 0 ) * stock BT 180 to 365 + 0.

  Please convert the formula in general words i am not able to get the logic built in it .

  Thanks and Regards,

  Gopichand.

[Former Member · Accepted solution]

Hi Gopi,

should be like this

IF stock BT 180 to 365 < 0 AND GR till 180 days >= 0 

    RESULT = stock BT 180 to 365 + GR till 180 days

ELSEIF

   stock BT  180 to 365 >= 0 AND GR till 180days >=0

RESULT = GR Till 180 days

ELSEIF

  stock BT 180 to 365  <0 AND GR till 180 days <0

RESULT = stock BT 180 to 365

ELSE

RESULT= 0.

[Former Member]

thank for responding Jyothi