Skip to main content
Solved

Statement condition

  • 5 March 2024
  • 2 replies
  • 32 views

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

=((FXFundRequestDetails.ExtCost] <= 100000) 

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 (dFXFundRequestDetails.ExtCost <= 250000.

In a GI or Report Designer conditions you can also use the Between condition.

Hope this helps!

Laura 


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

This took me longer to process than it should have 🙂


Reply