HCL Domino Ideas Portal
Welcome to the #dominoforever Product Ideas Forum! The place where you can submit product ideas and enhancement request. We encourage you to participate by voting on, commenting on, and creating new ideas. All new ideas will be evaluated by HCL Product Management & Engineering teams, and the next steps will be communicated. While not all submitted ideas will be executed upon, community feedback will play a key role in influencing which ideas are and when they will be implemented.
For more information and upcoming events around #dominoforever, please visit our Destination Domino Page
It would be a high time to be implemented in v14
Grand Total is a total of all categories, that number at the bottom. You cannot hide it even user does not have access to documents that are in the view.
For example you have project totals. Each project manager see its project totals / categories. But all see total for all projects. This is a stopper in real life.
Difference is that empty categorized sections can be hidden if user has no allowed docs to show. But total is always displayed. This is a NO GO for security reasons.
This is long overdue.
Best would be to have a calculated option for display of total in certain category and a formula for grand totals.
Usually views with totals and permission based access show only non-empty categories, that have docs user can access. But then user also view grand totals, that is should not.
Also like specified in first statement, it would be nice to have a formula like:
@If(CategoryValue="My Projects"; show_totals; do_not_show_totals)
I think that "calculated option" is related to visibility of Grand totals at the bottom of a view.
I think that It would be also very useful to have this option for categorized column. So you can define that this column total, sum etc. value (usually first categorized column) is not to be shown for this categorized view. The reason for this is for example view that shows your bank accounts balance - Col2 cat shows currency and col3 amount of money. Then showing sum of EUR and USD accounts in Col1 cat. can be confusing for users.
>Col1 cat.
330 (this is not desired to be shown)
>Col2 cat.
30
Col3 standard
10
Col3 standard
20
>Col2 cat.
300
Col3 standard
100
Col3 standard
200
Calculated/computed of visible flag to show grand totals or not.
What is the difference between a calculated and a grand total ?