Percentage is incorrect in report footer

[CMTH]

I have a percentage calculation that displays correctly in a query
(0.979166666666667), but when this value is displayed in a report footer,
100% is displayed.
I am seeing the same problem with a percentage displayed in an operator
footer within the report.
Both values are formatted as Percentage in the report.

If I display this value in the detail section of the report, 97.92% is
displayed correctly.

 

[Duane Hookom]

Can you share some calculation expressions as well as control sources? Is the
text box for sure in the Report Footer and not the Page Footer?

Is the column/field left or right-aligned in the report's record source
datasheet view?

 

[CMTH]

The calculation I am using in the query that returns the correct percentage is:
Uptime2: Sum([Available hours minus DT])/([Available hours])

Available hours is basically 8 times the number of date entries in a table
and Available hours minus DT is the available hours calculation minus another
general number in minutes, say 20.
I converted the available hours into minutes to perform the calculation
against the 20 minutes, and then converted that total number back into hours
to perform the above calculation.
Again, the query is returning the correct percentage, but the report footer
is showing 100%.

The text box is in the report footer
The column/field is centered
The control source is Uptime2 from the query

 

[CMTH]

Some addtional informaiton:
For the Uptime2 calcualtion mentioned below, the query returns a total of
two records for my example, one being 100% and the other being 97.92%.

Within my query, there could be multiple records returned and some will be
100%, while others will be some other percentage less than 100%.
In the end, I am looking to sum up all of the percentages that are not 100%,
and display that value in my operator footer and report footer.

The calculation I am using in the query that returns the correct percentage is:
Uptime2: Sum([Available hours minus DT])/([Available hours])

Available hours is basically 8 times the number of date entries in a table
and Available hours minus DT is the available hours calculation minus another
general number in minutes, say 20.
I converted the available hours into minutes to perform the calculation
against the 20 minutes, and then converted that total number back into hours
to perform the above calculation.
Again, the query is returning the correct percentage, but the report footer
is showing 100%.

The text box is in the report footer
The column/field is centered
The control source is Uptime2 from the query

Can you share some calculation expressions as well as control sources? Is the
text box for sure in the Report Footer and not the Page Footer?

Is the column/field left or right-aligned in the report's record source
datasheet view?

 

[Duane Hookom]

If you expect to "I am looking to sum up all of the percentages that are not
100%,
and display that value in my operator footer and report footer." I'm not
sure how you expect to get this result with simply binding a raw column
value... [Uptime2]. This will only display the final Uptime2 from your
report's record source.

If you need a sum of percentages then I would expect to see "Sum()" in your
expression.

I am currently working in a manufacturing facility and I can't imagine
summing up all of the percentages.

--
Duane Hookom
Microsoft Access MVP

Some addtional informaiton:
For the Uptime2 calcualtion mentioned below, the query returns a total of
two records for my example, one being 100% and the other being 97.92%.

Within my query, there could be multiple records returned and some will be
100%, while others will be some other percentage less than 100%.
In the end, I am looking to sum up all of the percentages that are not 100%,
and display that value in my operator footer and report footer.

The calculation I am using in the query that returns the correct percentage is:
Uptime2: Sum([Available hours minus DT])/([Available hours])

Available hours is basically 8 times the number of date entries in a table
and Available hours minus DT is the available hours calculation minus another
general number in minutes, say 20.
I converted the available hours into minutes to perform the calculation
against the 20 minutes, and then converted that total number back into hours
to perform the above calculation.
Again, the query is returning the correct percentage, but the report footer
is showing 100%.

The text box is in the report footer
The column/field is centered
The control source is Uptime2 from the query

Can you share some calculation expressions as well as control sources? Is the
text box for sure in the Report Footer and not the Page Footer?

Is the column/field left or right-aligned in the report's record source
datasheet view?

--
Duane Hookom
Microsoft Access MVP


:

I have a percentage calculation that displays correctly in a query
(0.979166666666667), but when this value is displayed in a report footer,
100% is displayed.
I am seeing the same problem with a percentage displayed in an operator
footer within the report.
Both values are formatted as Percentage in the report.

If I display this value in the detail section of the report, 97.92% is
displayed correctly.