Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
dranjbar
Contributor III
Contributor III

Button - Select Values in a field - Multiple with a >

Id like to make a button which selects these "AR Days Band" which all have a < or > symbol inside them.

My usual approach is typing in the Value textbox. ='value1;value2;value3' which selects the 3 values with the button although i believe since the values have less than or greater than signs in them, it doesn't actually select anything.

I have included a screenshot below on what I am using as the Value as mentioned above (I've also tried some other things I have read in the forums but I cant find a solution to this). 

Is anyone able to help me with this? Thanks!

dranjbar_0-1605059478796.pngdranjbar_1-1605059674610.png

 

 

2 Replies
MayilVahanan

Hi @dranjbar 

Instead of using the symbol field, you can bring one num field & try like below


Load *, RowNo() as [AR Day Num] Inline
[
AR Day
<=65 Days
>70 Days
>=75 Days
80 Days
];

MayilVahanan_0-1605065854583.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
dranjbar
Contributor III
Contributor III
Author

Unfortunately there isnt a AR Day Num field as the values are literally saved as "<75 days" etc (something like 70 days doesnt exist)