Working with list elements

hcl-bot · March 1, 2004, 8:49am

Hi,

I have a multi-value field: ActualWeight. I then have other multi-value fields that will be computed, depending on values in the ActualWeight field.

For example, I need to determine the maximum value and minimum value in sets of 5 elements and then subtract them, at every set 5 level. For example:

Element #: Actual Weight: R:

```
     15              -
```
```
     20              -
```
```
     10              -
```
```
     25              -
```

     25              15(max[25]-min[10])

```
     30              -
```
```
     05              -
```
```
     12              -
```
```
     15              -
```

    20              25(max[30]-min[05])

But there will be a undetermined number of elements in the list, can be 5, 10, 12, 14, etc. But it needs to be calculated for every set of 5, the rest must be filled with “-”.

I’ve racked by brain, trying to work with sets of 5 in LotusScript and Formula Language, the first 5 works perfectly, but I don’t know how to set the next 5, etc.

Any help in the right direction will be appreciated.

Thanks

hcl-bot · March 1, 2004, 9:08am

Subject: RE: Working with list elements

@Transform(yourlist; “x”; @Do(

	_pos := _pos + 1;

	_mod := @Modulo(_pos; 5);

	@If(_mod = 1;

		@Do(

			_min := x;

			_max := x;

			"-"

		);

		@Do(

			_min := @Min(x; _min);

			_max := @Max(x; _max);

			@If(_mod = 0; @Text(_max - _min); "-")

) ) ) );