Using view totals for calculations

HCL Domino Domino Forum
1

I need to know how to access view totals to perform calculations on a form. Is this possible? If so, please give me a starting point.

Thanks,

Duane E Grayson

2

Subject: Using view totals for calculations

It’s not possible just by creating totals in the view, although you might be able to access them in LS by using the document.ColumnValue.

Nope, just checked the help file and you won’t be able to do that because you can only access values relating to the current document. You might, via LotusScript, be able to loop through documents in the view to add up the totals that the view creates automatically.

3

Subject: RE: Using view totals for calculations

You should be able to pull the totals with the ColumnValues property of the ViewEntry (not the document, of course). Check for IsCategory and/or IsTotal before trying to pull the total.

4

Subject: RE: Using view totals for calculations

Thanks for your response.

Duane Grayson