I am building a database to manage tasks.

Each time a task is generated, a record is created and the task is assigned to a worker.

I have a field [COUNT] that counts how many tasks have been assigned to each worker.

I would like to figure out what percentage of all the tasks each worker is responsible for.

The calculation that comes to mind is [COUNT] / [TOTAL RECORD QTY].

I cannot, however, figure out how to post the total quantity of records in my database. When I try GET(Recordnumber) it just posts the number of records in a Found Set, rather than the number of records in the whole database.

Perhaps I am doing this altogether wrong, and I should be using a different formula?? Could somebody shine some light on this for me?

Thanks,

Jarvis

PS: I have already done a search on this topic in this forum

and I have been to the FM help files.

The correct function that you have to use is:

Get(TotalRecordCount)

thanks Daniele!

One thing I should point out to you so you don't go on believing something that's false. You said...

When I try GET(Recordnumber) it just posts the number of records in a Found Set, rather than the number of records in the whole database.

Get(RecordNumber) shows the position (as defined by sort order) of a given record in the found set.

Get(FoundCount) shows the number of records in a found set.