Select both +ive and -ive values from one field 1

[edteck]

A Field &quot;Spares Issues/Returns&quot; contains both negative and positive values. I need a formula to select negative values say, <= -2000 and positive values >= 2000. Could anybody assist?

 

[kenhamady]

Is this a selection formula?
You could use two clauses with an &quot;OR&quot; between them.

Or you could use absolute Value:

ABS({field}) >= 2000 Ken Hamady

http://209.41.46.214/

 

[edteck]

Yes, it is a select formula {Issues.Value}<=-1000 or
{Issues.Value}>= 1000. This did'nt work, because I mis-used it. It does now. Thanks for your help

 

[edteck]

More help needed on this. The field already has a formula in it e.g. Qty*UnitValue. When I apply {Issues.Value}<=-1000 or {Issues.Value}>= 1000 it returns True or False.

How do I convert formulas to values [Excel-style]? this would be one way round the problem.

 

[edteck]

Please forget my last question. ToNumber() is the answer.
Put my question down to grey cell deterioration - I can count them now. thanks

 

[kenhamady]

Or Val ()

But your selection formula should always be a True False. Formula fields can be anything. Ken Hamady

http://www.kenhamady.com/