I am trying to create a report with a blank column to divide out actual vs budget columns. When I run the report there are zeros on some rows but not others. I can’t figure out why it is pulling the zeros. Everything else looks correct for the actual columns.
Solved
Report column set - trying to get blank column
Best answer by srengdahl
I had to click suppress line on the column set for that column and that did the trick!
+13Take a look at your row set. If you have the “hide zero” check box selected, if the value is zero then it will be empty. However, this will affect evert column.
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.