Statement condition

  • 5 March 2024
  • 2 replies

Userlevel 3

How to change this statement to greater than or equal to 100,000 or less than or equal to 250,000?

=([FXFundRequestDetails.ExtCost] <= 100000) 


Best answer by lauraj46 5 March 2024, 04:40

View original

2 replies

Userlevel 7
Badge +7

Hi @ricoybanez ,

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!


Badge +11

Every value will be greater than 100k OR less than 250K

This took me longer to process than it should have 🙂


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved