Manage Learn to apply best practices and optimize your operations.

Dblookup Sums

Ever had a column of numeric data that you wanted to dynamically display the sum. By using a simple variation I came up with, the DBLookUp formula used with the @Sum command is very powerful. This formula lookup numeric data based on a key field. That data is then summed by the @Sum formula and stored to a variable which is error checked before being displayed.


Total := @Sum(@DbLookup("" : "NoCache"; Server : Database ; View; Key; Column Number or Field Name to return ));

@If(@IsError(Total); "Error!" ; Total)

This was last published in November 2000

Dig Deeper on Domino Resources - Part 3

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • 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 ...

SearchDataCenter

SearchContentManagement

Close