I have data in columns that i need to filter
In a column i have amounts ranging from -6,362 to 7,000 and want to filter out any amounts that are less them $1 either way
so if it is -0.99 or .99 I need to remove those amounts. But if it is a positive 1.01 or -1.01 I need to keep them.
Solved! Go to Solution.
@jlfromm - Use this in your filter:
abs([value]) > 1
Hi @jlfromm
I have tried it with some dummy amounts,
If you want, instead of Input text you can place your Input file, and I believe you will receive your data.
I have attached the workflow for your reference.