How to change this statement to greater than or equal to 100,000 or less than or equal to 250,000?
=([FXFundRequestDetails.ExtCost] <= 100000)
Solved
Statement condition
+5Best answer by lauraj46
Hi
Do you mean AND? Every value will be greater than 100k OR less than 250K. Assuming you mean AND, you can use a formula like this:
=([FXFundRequestDetails.ExtCost] >= 100000 and ([FXFundRequestDetails.ExtCost <= 250000.
In a GI or Report Designer conditions you can also use the Between condition.
Hope this helps!
Laura
+9Hi
Do you mean AND? Every value will be greater than 100k OR less than 250K. Assuming you mean AND, you can use a formula like this:
=([FXFundRequestDetails.ExtCost] >= 100000 and ([FXFundRequestDetails.ExtCost <= 250000.
In a GI or Report Designer conditions you can also use the Between condition.
Hope this helps!
Laura
+17Every value will be greater than 100k OR less than 250K
This took me longer to process than it should have 🙂
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.