Get(RecordNumber) does not seem to work; FM Adv 10.3
Description of the issue
I am trying to return a value in a found and sorted set that is the record sequence number in that found sorted set.I used the calculation function Get(RecordNumber) because it's purpose is described as doing just what I want in the FM Help. But it keeps returning impossible numbers that are not correct. For example, my found set has 35 records yet some of the returns is numbers over 35. How can this be? Can someone please help me determine if it is a software flaw or if I am doing something wrong. I suspect it is a software flaw because it is a simple calculation field with very little room for error. Any help is greatly appreciated. I need this ability ASAP.