Sequential #'s
im using a Var query var number sequencenumber = Size( GetRecords( "{53.ex.'"&[Related Profile]&"'}"&If(not IsNull([Record ID#]),"AND{3.LTE.'"&[Record ID#]&"'}"))); If([Status]="Active",$sequen...
Forum Discussion
Try adding another condition to your formula query for sequencenumber to include the status field equal to 'Active' as well. The size in the current formula query includes Expired records.