Sum of underlying document

HCL Domino Domino Forum
1

Hello

I have in view like

Category1

    9.5

    1.3

Category2

   3.3

   2.3

i want to take the handle of the category1 and want to sum 9.5 and 3.5 and then want to insert the same record in Excel and same with category2 and so on…

could any body please help?

Dev

2

Subject: sum of underlying document

lookup the NotesViewNavigator class on designer help. It gives you enough flexibility to navigate through view entries (documents and categories) and retrieve values.

You could also use column totals to make the calculation at the view level rather than in the code.

You can create excel.application object to create your excel workbook and transfer your data.

3

Subject: sum of underlying document

Dev,

Why keep asking the same question over and over again?

4

Subject: RE: sum of underlying document

sorry Mike… :slight_smile:

5

Subject: RE: sum of underlying document

No need to apologise Dev

I just think you will get a much better outcome if you keep to the same thread and include in your posts what you have tried/how far you have got/what stumbling blocks you are coming up against

This is a great community on this forum - we all do want to help each other - but you can only help those who help themselves

Have a good day and keep cracking away at that view!