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
binu_acs
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.

binu_acs
21 - Polaris

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

image.png

Labels
Top Solution Authors