I had two related list fields in my document,
Item and Weight. My users wanted the total weight field to exclude the wight of Carbon Dioxide (Item Code "CO2"). This seemed simple. Find out the Item element number = "CO2", and subtract the value of the same element in the weight list from the original summed field..... But all was not what it seemed.
Here was my initial code to get field TotalWeight:
Elem now contains the position in the array of the text "CO2", 2.
CO2Weight should now contain 20.00.
The total weight without CO2's weight.
But, Aargghh, CO2Weight returned the entire list of numbers... 10.00 ; 20.00 ; 30.00
Anyway, after a lot of faffing about, doubting my work, checking the manuals,
banging my head against the desk etc I finally searched the lotus knowledge base
and found this at
"The @Select function in Notes 4.x does not provide the ability to return the Nth
item of an arbitrary list. It will work only if you specify your semicolon-separated
list explicitly when you write the formula. How can a given element of a list be
returned using formulas?
Nested @Subset calls can achieve this, as follows:
Where N is a number representing which element you would like to select, with the
first element being number 1.
The inner @Subset call selects all elements of a list up to and including the number
you specify (1 through N). The outer @Subset selects just the last element of the
previous list (element N only).
In a similar way, you can access the Nth-to-last element of the list via:
In this case, the inner @Subset returns a list counting backwards from the end of the
list, consisting of N items, and the outer @Subset call returns the first of these (the
last element if N is 1, the second-to-last element if N is 2, etc."
WELL THANKS FOR TELLING US!!!
This was first published in November 2000