Formula language - count items in a multi value text field

HCL Domino Domino Forum
1

hi, i have a multi value text field. values can either be “registered”, “canceled” or “attended”. i need to do a coun of each using formula languge. how? ps this is notes R5.

2

Subject: Formula language - count items in a multi value text field

Hi Gwyn,

You could just create a view categorised by the multi-value text field, then add a column to the left with a formula value of 1 and change the column properties to calculate Totals - This will give you counts for the number of documents in each category.

If you need to calculate the numbers for use elsewhere, try using the @Elements command (which totals the number of elements in a list) on the results of a @DBLookup command to get the documents that match a given category.

The Domino Designer on-line help has descriptions on how to use these @Functions.

Hth.

3

Subject: Fairly simple…

Assuming your field is "Status"RegList := @Trim(@Replace(Status; “canceled” : “attended”; “”));

RegCount := @If(RList = “”; 0; @Elements(RList);

4

Subject: RE: Fairly simple…

nice one bill, that works like a treat