Skip to Content
avatar image
Former Member

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


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.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 30, 2015 at 04:43 AM

    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.



    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 06, 2015 at 07:06 AM

    thank for responding Jyothi

    Add comment
    10|10000 characters needed characters exceeded