A
Allison
I need to use a formula percentage of count.
I already established the count below.
=Count([APPL_ID])
I already established the count below.
=Count([APPL_ID])
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Fons Ponsioen
No clear as to what you want.
You have a count of lines, each line would be 1/count, is
this what you are looking for?
Come back with some more detail.
Fons
You have a count of lines, each line would be 1/count, is
this what you are looking for?
Come back with some more detail.
Fons
A
Allison
I have a field with records called COUNT.
I want my SUMMARY report to count the number of records in
that column or field and give me a percentage of count in
the other field
Count(Field label) % of Count(Field label)
NRFC has 1925 records
Pending has 1130 records
Terminated has 4 records
To be Paid has 74 records
Withdrawn has 1783 records
I want my SUMMARY report to count the number of records in
that column or field and give me a percentage of count in
the other field
Count(Field label) % of Count(Field label)
NRFC has 1925 records
Pending has 1130 records
Terminated has 4 records
To be Paid has 74 records
Withdrawn has 1783 records
-----Original Message-----
No clear as to what you want.
You have a count of lines, each line would be 1/count, is
this what you are looking for?
Come back with some more detail.
Fons
.-----Original Message-----
I need to use a formula percentage of count.
I already established the count below.
=Count([APPL_ID])
.
F
Fons Ponsioen
Alison.
First, -count- is a reserved word in access, do not use
this as a name for data fields.
I do not know how your data is stored. If the data table
structure is with each row having a true or false for each
of the catagories as you listed
APPL_ID, NRFC, Pending, Terminated, paid, Withdrawn
you could count the total number of records,
then Sum(Abs([NRFC])) etc.
the Sum(Abs([NRFC])) will give you a total number for
those records where NRFC is true. and
Sum(Abs([NRFC]))/Count([APPL_ID])
formatted as percent would give you the percentile. You
can repeat this same formula for the other conditions.
Hope this helps
Fons
First, -count- is a reserved word in access, do not use
this as a name for data fields.
I do not know how your data is stored. If the data table
structure is with each row having a true or false for each
of the catagories as you listed
APPL_ID, NRFC, Pending, Terminated, paid, Withdrawn
you could count the total number of records,
then Sum(Abs([NRFC])) etc.
the Sum(Abs([NRFC])) will give you a total number for
those records where NRFC is true. and
Sum(Abs([NRFC]))/Count([APPL_ID])
formatted as percent would give you the percentile. You
can repeat this same formula for the other conditions.
Hope this helps
Fons
-----Original Message-----
I have a field with records called COUNT.
I want my SUMMARY report to count the number of records in
that column or field and give me a percentage of count in
the other field
Count(Field label) % of Count(Field label)
NRFC has 1925 records
Pending has 1130 records
Terminated has 4 records
To be Paid has 74 records
Withdrawn has 1783 records
.-----Original Message-----
No clear as to what you want.
You have a count of lines, each line would be 1/count, is
this what you are looking for?
Come back with some more detail.
Fons
.-----Original Message-----
I need to use a formula percentage of count.
I already established the count below.
=Count([APPL_ID])
.