HiHas anybody succeded to find a solution for the Grand Total That also do show total for hidden Document.
I had try to use dif. formulas as @Ismember og @Contains to
Calculate the Column Content wihtout any result.
Any suggestions is appriciated
Subject: RE: Grand Total for hidden Document in Column
If you create a view that has a totaled column, you can read the NotesViewEntry of that row, which will be the last row. If it’s a categorized view, you can iterate through category entries to get the category-level totals.
You can’t do this with formula.
Subject: Thanks for the input[EOM]
Subject: Grand Total for hidden Document in Column
Hi,
If by hidden you mean $Readers documents where user have no rights - there is no answer, you cannot sum something you have no access to.
I would you suggest a scheduled agent on server (on back-end with server’s rights) to run each hour and put the sum in a different type of document document in database. So you have some “total” till last hour.
Ovidiu
Subject: RE: Grand Total for hidden Document in Column
No, that’s not the case – the problem is that the server has access to the documents, so in a public view (where the server is the entity doing the indexing), the grand totals will include documents the user can’t see, so that’s why the totals are off. The only answers are:
-
use a private view (Shared, desktop private on first use) so that the indexing entity becomes the user and only documents the user can see are included in the totals (moving docs to a private folder would work as well);
-
forget about totalling in the view, and run a report when the users need to see totals. You can display a report in rich text within Notes, or send it to a spreadsheet app like Excel or create an HTML document.