Skip to Main Content
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

Status Needs Review
Workspace Domino Designer
Categories Views
Created by Guest
Created on Mar 6, 2023

In a view the total row the column formula should apply

The Problem:

Currently in a view's total row one can only select for a column :

Either "None", "Total", "Average per document", "Average per sub-category", "Percent of parent category" or "Percent of all documents"

But this does not cover all user requests.

As it is not possible to add images here, please look for further details at Problem with totals row options in a Notes View in the Community forum.

As one can see do exist total row calculationa which are not covered by the current implementation in views.

In our company we need this for financial reports. We now need to export it to Excel ...

The Solution:

As the option "Total" exists and works fine for columns, these total values are calculated internally and available, but can not be used in the total options.

Lets assume you have 2 numeric columns where the option "Total" has been activated. Then allow in another column to use a new total option, let's call it "Column Formula". It should use the column value formula to calculate the total row by referencing the total values of these other 2 total columns.

If a referenced column has not set the option "Total" or is not numeric, then raise an error or assume a 0 value and use it the column formula. If an @command in the Column formula is not allowed in this total context, simply raise an error.

  • Attach files