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.

Do you have comments on this Ask the Expert Q&A? Let us know.

Related information from

  • 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?
  • Dig Deeper on Lotus Notes Domino Agents

    • Favorite iSeries cheat sheets

      Here you'll find a collection of valuable cheat sheets gathered from across the iSeries/ community. These cheat ...