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.
