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?
@taliatest use 0 instead of "0" in the formula because you are dealing with numbers
Thanks for taking a look! That didn't seem to solve the issue. I am still receiving all records in the output.
@taliatest try adding a few columns and see whether it is working or not