Reporting - Ability to hide Formula Rows in reports if the result is zero
It would be great to be able to hide formula rows in reports where the result is a nil balance. Currently we get multiple repetitive total lines on reports when there is no activity cluttering up the reports unnecessarily.
Kerrin Paget
shared this idea
Hi Kerrin, thanks for raising this. It’s easy to see how automatically hiding custom formula rows with no activity would make reports cleaner and easier to read.
Without this option, reports can feel cluttered. That often means sharing something that looks busier than it needs to be, or exporting the report just to remove empty rows manually—extra work that defeats the purpose of using the report builder.
I’ve moved this idea to Gaining Support so we can better understand interest in more report-level formatting options. If you’re able to comment with the specific reports where this would be most useful, it’ll help other users understand the use case and help the idea gain traction.
-
Kerrin Paget
commented
It's mainly the profit & loss reports. For example if there is only other income or expenses and no sales/trading income, the report has a nil line for gross profit and a nil % GP line.