Skip to Content
avatar image
Former Member

Formula Problem

Hello,

I am trying to implement a formula in BEx query designer, logic is :

if value <= 20 % of Y Quantity , then value should become 0 and if value > 20% of Y Quantity then result = Value X .

Please help on how to implement it or how to formulate it.

regards,

V

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    May 29, 2015 at 11:50 AM

    Hi,

    Do this:

    (VALUE <= (Y_QTY * 0.2) )

    * 0

    + VALUE_X



    OR


    (VALUE <= (Y_QTY * 0.2) )

    * 0

    + (VALUE > (Y_QTY * 0.2) )

    * VALUE_X

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded