Working with lists

HCL Domino Domino Forum
1

Hi,Is this at all possible:

I have a list with week numbers in, for example:

35; 35; 36; 37; 37; 37

I need to compute for each unique week no in a view with every week as a column, that field, how many there are. In other words, for week no 35, the value is 2, for week 36, the value is 1, for week 37, the value is 3.

2

Subject: Working with lists

what you need is @elements

Michael

3

Subject: Working with lists

There may be an easier way, but this one will always work (with text or numbers):

@Elements(origlist) - @Elements(@Trim(@Replace(origlist; weekno; “”)))

It removes the wanted value from the list and calculates the difference in length of the lists.

4

Subject: RE: Working with lists

Hi Jan,

Thanks for the reply. You have a field - origlist, I assume that is the list with the values (34, 34, 35, 36, 36, 36), but what is the weekno field you have in the formula?

5

Subject: RE: Working with lists

Sorry, got it figured out, thanks, it works 100%!