Lotus Domino Designer 8 Help - Examples: @Count

FORMULA LANGUAGE

Examples: @Count
1. This formula returns the value 3 when the stooges field contains the text list: "Moe":"Larry":"Curly":

@Count(stooges)

2. This code returns the value 1, even if there are 4 entries under the Kevlar category in the Sails view, when the value of the third column in the view is determined by the simple function, # in View:

@Count(@DbLookup("";"Server/Name/Notes":"Cost\\Materials.nsf";"Sails";"Kevlar";3))

This formula returns 1 because the list produced by the # in View simple function is a list of special text, not a standard number list. If @Count were replaced by @Elements, the formula would return 0.

3. This formula returns a list of the largest numbers after performing a pair-wise comparison of the elements in the Asia_total and USA_total fields, which contain number lists representing the monthly sales totals for the year in these two regions:

tAsia := @Count(Asia_total); tUSA := @Count(USA_total); dif := (tAsia - tUSA); result := @If(@Sign(dif) = -1;@Subset(USA_total;tUSA=@Abs(dif)); @Subset(Asia_total;(tAsia - dif))); @If(@Sign(dif) = -1;@Max(Asia_total;result);@Max(result;USA_total))

If the USA has not yet posted its fourth quarter sales totals, this formula displays only the results of comparing the figures posted for the first nine months. It does not follow the default behavior of repeating the September sales figure three times to even out the two list lengths.

See Also

@Count

Glossary

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Glossary