Size Query - Ranking and then Querying the Next Ranked Record

Hi Quick Base Junkie!
Thank you for your response!

I think I'm still getting stuck with my rank (Size Query Field) in tandem with a GetFieldValues() field.

Here's what I have so far for my Rank:

var text NRTR = "{6.EX.'" &[Related Unit]& "'}AND{39.LT.'" & [Lease Start] & "'}AND{142.XEX.'Application in Process'}AND{168.EX.''}AND{261.XEX.'Yes'}";

If([Lease Status]="Application in Process",null,
If(ToText([Lease Canceled])<>"",null,
If([Resident Transferring to Another Unit]="Yes",null,
Size(GetRecords($NRTR))+1)))

-or this-

var text NRTR = "{6.EX.'" &[Related Unit]& "'}AND{39.LTE.'" & [Lease Start] & "'}AND{142.XEX.'Application in Process'}AND{168.EX.''}AND{261.XEX.'Yes'}";

If([Lease Status]="Application in Process",null,
If(ToText([Lease Canceled])<>"",null,
If([Resident Transferring to Another Unit]="Yes",null,
Size(GetRecords($NRTR)))))


This is attempting to omit a few Statuses, which it is doing, but I'm noticing the Rank, when looking at a list of records in a report is: null, 1, 3.
Do you have any suggestions on how to make it null, 1, 2, for a group of 3 records that includes a record that should be ignored/omitted from being ranked?
Or, is there a way to salvage this in the next GetFieldValues()

For instance,
If I need to stick with null,1,3,
How might I write a GetFieldValues() Query that pulls a value from the Rank 3 Record, from the perspective of the Rank 1 Record?



Thank you for your help!

------------------------------
Liz Chartrand
------------------------------