Filter Function

[jlfromm]

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.  

[usmanbashir · Accepted solution]

@jlfromm - Use this in your filter:

abs([value]) > 1

[Gaurav0001]

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.