Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this?
If(NetAmount>=2000 or NetAmount <= (-2000), NetAmount)
Thanks for replying. I tried but it didn't work it is showing all amounts.
-V