Total Columns in a view

HCL Domino Domino Forum
1

I have a time tracking database and employees’ time is catergorized and totaled in a view. Is there a way to do one of the 2 things requested of me:

  1. Hide the Zero totals or display a blank instead of 0.00

OR

  1. Bold or colorize non-zero totals

The reason is that the 8 hours in a work day, 8.00, looks a heck of a lot like 0.00 in the view no matter what font I use.

Thanks for you help,

Quin

2

Subject: RE: Total Columns in a view

There’s no way to make the total a different color if it is zero, nor to make it blank if it is zero. Even if you could do this, however, you still have the problem that 8.50 hours looks a lot like 0.50 hours.

If your employees never report negative hours, then you should be able to hide the zero totals by using the selection formula to exclude from the view any documents that don’t report any hours.

Or, generate your own report on the fly using a rich text field, then you could format everything however you like.

I have to tell you, though, I have no trouble distinguishing an 8 from a 0 in any normal font, provided they’re displayed big enough to see…