Is there a way to hide the grand total on a column?

HCL Domino Domino Forum
1

I have a categorized view, which lists all timeslips. However users can only see their own timeslips. I have a column that totals the hours (subtotal by category so they can see how much they’ve billed for the day) however the grand total at the bottom totals all timeslips (not just their own) which is the cause of a lot of confusion. So…

1.) Can I make the grand total show only the totals viewable by the user, i.e. not the grand total

2.) or Can I hide the grand totals altogether (but still keep subtotaling by category?

2

Subject: How to fix the grand total

Hi all.

Problem: You have a categorized column with a total on it. You use Readers fields in your documents and users can only see their own docs in that view. However, the grand total at the bottom of the column shows the total of all documents.

Solution: Use the following formula in the total column - modified to fit your fields. I use it to toal attachments.

tsum := @Sum(@AttachmentLengths);

sum := @If(@IsError(tsum); 0; tsum);

@If(@IsNotMember(Readers;@Name([CN];@UserName));0;sum)

3

Subject: is there a way to hide the grand total on a column?

What you see in the view is what you get.

Rethink the UI. Think dashboard. Think form with user name and some lookups…maybe an embedded single cat view. Think hide all the stuff the user doesn’t need to see.

You may want to take a peek at Interface Matters or Escape Velocity for some ideas - awesome stuff out there that’ll have you totally rebuilding your apps.

HTH

Doug