Hi there,
Does Alteryx Designer have a something similar to a BETWEEN function? For example, if I wanted to find records with a transaction amount between 1,000 and 5,000 dollars, I could write a formula as follows:
BETWEEN(Transaction_Amount, 1000, 5000)
And all of the records that had a transaction amount between and including 1,000 and 5,000 would be displayed.
Is there a similar function in Alteryx Designer, or must this expression be written the "long" way:
Transaction_Amount >= 1000 AND Transaction_Amount <= 5000
Thanks in advance for your help!
Mike
Solved! Go to Solution.
@mkeiffer - 2023.1 is here and it includes BETWEEN 😀: https://community.alteryx.com/t5/Analytics/2023-1-Enterprise-Ready-Cloud-Friendly/ba-p/1116702?utm_s...
@ArtApa Thanks so much for the heads up. I just downloaded the new version today. Thanks again!
We have just released this new Between function today in our 23.1 release! Hope you can check it out! 😁
@NicoleJ Thank you so much! I just downloaded the latest version today. Thank you again for the heads up on this!