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
View originalStatement condition
Userlevel 3
+11
Every value will be greater than 100k OR less than 250K
This took me longer to process than it should have 🙂
Userlevel 7
+7
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
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.