Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.


Tags:
Former Member
Former Member replied

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.



1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question