Manage Learn to apply best practices and optimize your operations.

Another Totaling @Function

I was building an array with a HTML view for the web and needed a good way of
dynamically keeping the total number of items used to build the array. I
wasn't counting the documents but the keywords used and if if the keyword was
used '3' times them it needed to be counted 3 times in the array.
View information
View Column 1:
formula: = field name
select show multiple values as seperate entries
View Column 2:
Formula: 1
Total = On

Field Information:
Text field
Compute for Display
with the value shown in the Code:

The dbcolumn will return 1;1;1;1;3;3;2;1;13. 13 being the grand total.
list := @DbColumn("" : "NoCache"; "" ; "(count view)"; 2);
number :=@Subset( list ; -1 );

@If(@IsError(number) ; 0 ; number)

This was last published in November 2000

Dig Deeper on Domino Resources - Part 2

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