Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Get values between two numbers using formula

Meghnagupta
8 - Asteroid

Hi, I am trying to use below formula but it doesn't work.

 

1. tonumber(if [Dep Ledger Bal] <= 100000 then [Dep Ledger Bal] else '0'
endif)

 

2. tonumber(if [Dep Ledger Bal] >= 100000 <= 250000 then [Dep Ledger Bal] else '0'
endif)

 

3. tonumber(if [Dep Ledger Bal] < 250000 then [Dep Ledger Bal] else '0'
endif)

 

Basically, I want to get values between 100,000 and 250,000 from column named Dep Ledger balance. I am able to get values in 1st and 3rd formula but unable to get for 2nd one. Can someone please help?

1 REPLY 1
binuacs
21 - Polaris

@Meghnagupta 

 

tonumber(if [Dep Ledger Bal] >= 100000 And Dep Ledger Bal]  <= 250000 then [Dep Ledger Bal] else '0'

Labels
Top Solution Authors