Filter values greater than 2000

[vsap2000]

Hello Guys,

I want to get Net Amt that is greater than 2000  or -2000 (Absolute Value) for the Sales Number using the Exact Value limitation as shown in attached file. I am able to use >= 2000 but not able to get anything >= -2000.

Thanks in advance.

-V

[Anil_Babu_Samineni]

May be this?

If(NetAmount>=2000 or NetAmount <= (-2000), NetAmount)

[vsap2000]

Thanks for replying. I tried but it didn't work it is showing all amounts.

-V