Skip to Content

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

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

Former Member
replied

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

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