Omitting Archived Records From Total Count
In my solution I send all records to archive rather than delete. This is acheived by setting a record's status using an 'Archived' field who's value is a boolean.
I currently show the record number, total of found set, and records in total for all my tables using merge fields on my layouts. I use three auto-calculated fields in each table which calculate the aforementioned values.
Get ( RecordNumber )
Get ( FoundCount )
Get ( TotalRecordCount )
How would I go about subtracting the number of archived records from the total?
Thanks in advance