I have a formula that brings an error " .. A number is required here ... ". See the code snippet below which i have simplified. In the actual formula, the function NthLargest is being accessed in a loop hence the need to have the first parameter being a variable (pos):
Expand|Select|Wrap|Line Numbers
- numberVar pos := 1;
- NthLargest (pos, {Table1.score});
Question is, how do i go through a loop where the N variable is changing after each iteration in the NthLargest function ?
NB: The field score in Table1 is a Long Integer (Database = Access).