We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to remove all lines with 0 values

taliatest
7 - Meteor

Hello! I am attempting to remove all lines from my file with 0's in each of the Period Value Columns, shown in the image. For example, the highlighted rows all have 0 balances, and they should be removed. The rows that are not highlighted should remain because they have at least one value that is not 0.

 

I attempted to use this formula to filter shown on the left-hand side of the image to filter all of these rows out, but I am not getting any results. The output is just the original data set with no changes. Can anyone advise the best way to accomplish this? Screenshot 2025-03-17 131123.jpg

3 REPLIES 3
binuacs
21 - Polaris

@taliatest use 0 instead of "0" in the formula because you are dealing with numbers

 

taliatest
7 - Meteor

Thanks for taking a look! That didn't seem to solve the issue. I am still receiving all records in the output.

binuacs
21 - Polaris

@taliatest try adding a few columns and see whether it is working or not

image.png

Labels
Top Solution Authors