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 SearchDomino.com:

  • 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



    • iSeries tutorials

      Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

    • V6R1 upgrade planning checklist

      When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

    • Connecting multiple iSeries systems through DDM

      Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...