Alteryx Designer Desktop Discussions

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

Order level balance between -1 and 1

Amy123
8 - Asteroid

Hi , 

 

How to write this condition on alteryx.

 

Thanks

2 REPLIES 2
Sebastiaandb
12 - Quasar

@Amy123 Could you elaborate a bit more on your condition? 

 

If you want to filter your data on the attribute/variable "ORDER_LEVEL_BALANCE" and it should be between the values of -1 and 1 then the expression in your filter tool would be:

 

Sebastiaandb_0-1637652853940.png

 

Greetings,

 

Seb

 

 

binuacs
20 - Arcturus

I agree to @Sebastiaandb , I think the between should include -1 and 1 as well in that case the condition should be like below

 

Spoiler
binuacs_0-1637653419470.png

 

Labels