Sums and percentages in reports

[Robbie Doo]

I have the following field in report's detail area:

=Count([Cause]=1)

(where 1 refers to a row of a table's dropdown)

at the report footer I have the following sum for that column:

=Sum(Abs([Cause]=1))

with the Runnin Sum - Over All.

The calculation comes out correc so I'm assuming the formulas are correct.
However, when I try to get a Percentage by deviding the field formula with
the footer formula I don't get the correct answer. Can someone help me with
this formula?

 

[Duane Hookom]

You have told us what you attempted but it isn't clear what you want to
accomplish. Your expression "=Count([Cause]=1)" will return the number of
non-null Cause field values. Also, I don't have a clue why you are using a
running sum.

Can you provide us with something like:

I have a numeric field [Cause] in a report and I want to count the number of
records that have a 1 in this field and also.. all in the ... section of the
report

 

[Robbie Doo]

Thank you Duane for your response. You guys are very helpful. I figured out
the answer already.

You have told us what you attempted but it isn't clear what you want to
accomplish. Your expression "=Count([Cause]=1)" will return the number of
non-null Cause field values. Also, I don't have a clue why you are using a
running sum.

Can you provide us with something like:

I have a numeric field [Cause] in a report and I want to count the number of
records that have a 1 in this field and also.. all in the ... section of the
report


--
Duane Hookom
MS Access MVP

I have the following field in report's detail area:

=Count([Cause]=1)

(where 1 refers to a row of a table's dropdown)

at the report footer I have the following sum for that column:

=Sum(Abs([Cause]=1))

with the Runnin Sum - Over All.

The calculation comes out correc so I'm assuming the formulas are correct.
However, when I try to get a Percentage by deviding the field formula with
the footer formula I don't get the correct answer. Can someone help me
with
this formula?