Financial Report Designer, we have adding column for percentage formula. How I can hide any accounts is zero balance ?
I have been using 'Z' on column C but the percentage formula is error. (if deleted 'Z' that report is success but any account is zero balance will show.
Hi Thaworn,
Another option is to use the FRS financial reporter. There's a setting in row sets to suppress a row if all the columns on that row are zero.
A nice thing about FRS is that it uses referenced row and column sets, so if you have multiple income statements, they can all use the one income statement row set. That way you only need to make a change once which saves time and ensures consistency between reports.
Hi Thaworn,
Another option is to use the FRS financial reporter. There's a setting in row sets to suppress a row if all the columns on that row are zero.
A nice thing about FRS is that it uses referenced row and column sets, so if you have multiple income statements, they can all use the one income statement row set. That way you only need to make a change once which saves time and ensures consistency between reports.
