Hello Forum Users,

I've been fighting with a set of F/S to meet a client's desired presentation. They use, and have been using for some time, the following format for their I/S:

Revenue
Deferred Revenue PY xx
All Revenues xx
Deferred Revenue CY xx

The appropriate rows are hidden based upon the department the report is being run on, other revenues are broken down by the smart sheet, etc. works great.

The problem:
I've been asked to add a $ to the statement as the client has been exporting to Excel and manually adding the $. I cannot just add the $ to the Deferred Revenue PY line, as not all departments have a GL value for that account.

The easiest solution, as 99.9% of their departments have some type of Revenue (if not deferred) would be to reorganize the report and have All Revenue followed by PY and CY Deferred Revenue lines with the $ on the All Revenue line. This isn't the presentation the client would like.

If anyone has any suggestion or could point me towards some reading on how to accomplish that it would be appreciated. Thanks.