Calculate total of a field for a document collection

HCL Domino Domino Forum
1

I want to calculate total of a field for a document collection.One way is to loop through all the documents. Is there any other efficient way.

2

Subject: RE: Calculate total of a field for a document collection

No, but where did you get the collection from? There might be a way to get the total from the source.

3

Subject: RE: Calculate total of a field for a document collection

Thanks for your prompt response.Actually I have used NotesViewEntryCollection using GetAllEntriesByKey. I am reading the values using dbcolumn within for loop and then finding the total. Somehow i am not very confident with this approach. Pls. advise.

4

Subject: RE: Calculate total of a field for a document collection

Thanks for your prompt response.Actually I have used NotesViewEntryCollection using GetAllEntriesByKey. I am reading the values using ColumnValues within for loop and then finding the total. Somehow i am not very confident with this approach. Pls. advise.