TylerFoy81
7 months agoQrew Trainee
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...
- 7 months ago
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.