I have created a replicating NL function in order to populate our list of general ledger account numbers. Separately, I've created columns to pull the balance per account per month using the GL function. I would like to create an "if" function to hide all rows where there the general ledger balance for all months is zero. When I build the "if" function in column a, it replicates the "if" statement but adds "+ auto" to the end. The "+auto causes" the function to error out in excel so it doesn't hide my zero value rows. If I add the "if" formula to any other column it won't replicate. Is there any way to fix this?
Date
Votes
3 comments
-
Jet Reports Historic Posts Official comment Hi Julie Taylor
I'm new to this forum too but just did something like this today to suppress zeros. What I would suggest is to insert a column after column A just to give yourself some space. So in column B1 I would put type "Hide+?" without the quotes.
Then also in column b next to the rows you want to hide key a conditional hide formula like this, =IF(AND(G10=0,H10=0,I10=0,J10=0),"hide","show") mine will hide rows that are zero in all four cells. Well you’ll need to change the formula to fit your spreadsheet but it should work for you.
A -
Jet Reports Historic Posts Hide+? did the trick! Thanks for your help
-
Jet Reports Historic Posts No problem - glad I could help someone even though I'm a novice user…. :D
Please sign in to leave a comment.