How to change this statement to greater than or equal to 100,000 or less than or equal to 250,000?
=([FXFundRequestDetails.ExtCost] <= 100000)
Answer
Statement condition
+3Best 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
+8Hi
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
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
+15Every value will be greater than 100k OR less than 250K
This took me longer to process than it should have 🙂
Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.