A New Home in the New Year for SAP Community!

Exciting times ahead for the SAP Community! We've outgrown our home, so we'll be migrating to a new platform later this year. Let's continue the journey together!

Sep 01, 2011 at 09:50 AM
# how to write this formula??

Hi

I am trying to create one formula in query designer and use it in Condition in Query designer..but its failing for some reason.Can anybody see why its failing?

Defintion is:

Either X NOT EQUAL TO ZERO or Y not equal to zero and A-(X+Y) SHOULD BE IN BETWEEN 0 AND 150

X,Y,A are selections where as A-(X+Y) is a formula.

The query should show all items that pass the above condition.

I created formula like below

1*((0<=A-(X+Y)<=150)AND((X NE 0) OR (Y NE 0))).

My query is showing items which it should not be shown.I think the condition is passing these items eventhough it shouldnot.

Once I save,the formula is becoming automatically like below:

1*(((0<=A-(X+Y))<=150)AND((X NE 0)OR(Y NE 0)))

Can anybody helpout?

Thanks.