Problem solve
Get help with specific problems with your technologies, process and projects.
Calculating results for a column in a Lotus Notes view
Find out what types of calculations can be computed for a column in a Lotus Notes view and the best way to go about it with this expert response.
Is it possible to get high/low results computed for a column in a Lotus Notes view? The data is a text field using Notes Domino Formula language. I don't mind if it is only a high or low shown in the same way as a Total. Can you help me out with this?
The only calculations that can be done within a view column are totals and averages. You could write an agent in a view action that would run through the documents in a view and calculate the high and low. You could then display that in a prompt. You could also export the data to a spreadsheet where this and other information may be calculated.
Tip: Write HTML and JavaScript in view rows and columns on the Web
Tip: Do I use Formula or LotusScript to include a doclink to a Notes view?
Do you have comments on this Ask the Expert Q&A? Let us know.
Related information from SearchDomino.com:
