I have a report basically made up our total hours, expenses and disbursements.
If either the expenses or disbursements are 0, I would like to leave them off the report. However, when I do this (omit an items with a 0 balance) I then get Error! in my totals column e.g.
Total hours 100.00
GST on Hours 7.00
Expenses Error!
GST on expenses 0.00
Disbursements Error!
GST on disbursements 0.00
Total Error!
The reason I don't want to list either expenses or disbursements if the total is 0 is because it takes up too many lines.
Any ideas.
Thank you
If either the expenses or disbursements are 0, I would like to leave them off the report. However, when I do this (omit an items with a 0 balance) I then get Error! in my totals column e.g.
Total hours 100.00
GST on Hours 7.00
Expenses Error!
GST on expenses 0.00
Disbursements Error!
GST on disbursements 0.00
Total Error!
The reason I don't want to list either expenses or disbursements if the total is 0 is because it takes up too many lines.
Any ideas.
Thank you
