Rank using a query

Hi everyone, 

I have a list of records that I need to rank, first by the expected start date, then by the final date required, then by the build priority, and last using the record ID.  One thing to note is that the expected start date field is usually blank.

This is the formula I am using currently, and it is working with the exception that if a record has the expected start date populated then it numbers those and then starts the numbering over again on the records that do not have a date entered in the expected start date.  For example if 2 of my records have an expected start date they would be ranked 1 & 2, then the next record (without an expected start date but with the earliest final date required) would again be ranked 1. 

I have referenced Quickbase Junkies videos which is how I got this far.  Any help/suggestions would be appreciated.

var text QZER = "{289.EX.'true'}AND{58.EX.'"&[Region]&"'}AND{45.EX.'"&[Data Center Name]&"'}AND{148.BF.'"&[Expected Start Date]&"'}";

var text QONE = "{289.EX.'true'}AND{58.EX.'"&[Region]&"'}AND{45.EX.'"&[Data Center Name]&"'}AND{148.EX.'"&[Expected Start Date]&"'}AND{129.BF.'"&[Final Date Required]&"'}";

var text QTWO = "{289.EX.'true'}AND{58.EX.'"&[Region]&"'}AND{45.EX.'"&[Data Center Name]&"'}AND{148.EX.'"&[Expected Start Date]&"'}AND{129.EX.'"&[Final Date Required]&"'}AND{47.LT.'"&[Build Priority]&"'}";

var text QTHR = "{289.EX.'true'}AND{58.EX.'"&[Region]&"'}AND{45.EX.'"&[Data Center Name]&"'}AND{148.EX.'"&[Expected Start Date]&"'}AND{129.EX.'"&[Final Date Required]&"'}AND{47.EX.'"&[Build Priority]&"'}AND{10.LTE.'"&[Record ID]&"'}";

 

 

Size(GetRecords($QZER))+Size(GetRecords($QONE))+Size(GetRecords($QTWO))+Size(GetRecords($QTHR))

------------------------------
Emma Finger
------------------------------