Skip to main content
Solved

Statement condition


ricoybanez
Jr Varsity III
Forum|alt.badge.img

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

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!

Laura 

View original
Did this topic help you find an answer to your question?

2 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 511 replies
  • Answer
  • March 5, 2024

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!

Laura 


darylbowman
Captain II
Forum|alt.badge.img+13
lauraj46 wrote:

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

This took me longer to process than it should have 🙂


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings