Include in output if amount in an specific column is more that $600 and more than $-600

[Jmaldonado]

Hi,

I'm trying to create an if statement to exclude from the output anything that is less than $600 or less that $ -600 for either sum 1 or sum 2 columns. In other words, exclude anything between $600 and $-600. Attached output file for your reference. 

[atcodedog05]

Hi @Jmaldonado 

Formula in filter would be something like below. Where its checking that Sum1 & Sum2 are both lesser than 600 and greater than -600

([Sum 1]<=600 and [Sum 1]>=-600)

AND

([Sum 2]<=600 and [Sum 2]>=-600)

Workflow:

Hope this helps 🙂