Counting

HCL Domino Domino Forum
1

I have four columns in a view. The first is the username, which has a twistie. The second column value is the month by number (so March would be 3). This second column is multi-valued. It could have 3,3,3,4,6

The third column is also multi-valued and is either a 1 or 0.5. It is related to column two in that for each value in column two, there is a value in column three.

The fourth column currently adds column three up, which is then totalled by person.

I want column four to show only the values in column three that are based on the numbers 1,2 & 3 from column two.

At the moment this is what happens

E.g.

NAME MONTH DAYS SUM

John Smith 3,3,3,4 1,1,1,0.5 3.5

I want it to do this though (Find the first three numbers in column two are 1,2 or 3, then find the values for them in column three and add them)

E.g.

NAME MONTH DAYS SUM

John Smith 3,3,3,4 1,1,1,0.5 3

2

Subject: Counting

I think this is what you are looking for… Put something like this in the last column…

Mos:=@Explode(Months);

nums:=@Explode(Vals);

temp := “0”;

@For(n := 1; n <= @Elements(Mos); n := n + 1;

@If(Mos[n]=“1” | Mos[n]=“2” | Mos[n]=“3”;

temp := temp + nums[n] + “~”;

temp:=temp + “0”+ “~”));

rslt:=@TextToNumber(@Explode(temp ; “~”));

@Sum(rslt)

3

Subject: RE: Counting

Thanks Philip, tried and it seems to be having some troubles. First it was incorrect data type, so I used @text to change it to text. But now it just shows all 0’s in the column. Will play around with it a little more though.

4

Subject: RE: Counting

Hi Michael,

OK, i wasn’t sure what field types you were dealing with. If the month and the number value fields are number fields it would be more like this…

Mos:=Months;

nums:=Vals;

temp := 0;

@For(n := 1; n <= @Elements(Mos); n := n + 1;

@If(Mos[n]=1 | Mos[n]=2 | Mos[n]=3;

temp:=temp + nums[n];

temp));

temp

5

Subject: RE: Counting

Thanks Philip, worked a treat!