Percent showing hundreds instead of actual percent number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an expression and it returns a percent in a report but in that report
it shows it as 200.0%. This only happens when my date range parameter is
more than over a year period. It works fine for a few months date range but
when I ask for Date range of 8/15/2005 end date 4/15/2006 that is when it
returns 200.0%.
In the report, I have that field set to format to % with 1 decimal place.
Here is the expression.

Expr1: [Reason code totals by date range-Retention and NAVSEA]![SumOfPoint
Value missed]/[Summary exam pts all avail for Retention and
NAVSEA]![SumOfPoints allotted]

Does anyon know how to solve this issue?

Thanks for your help in advance.
 
I'm not sure how you expect anyone to help you when we don't know anything
about your data. It seems that you are having a problem in your report yet
you are showing us a calculation in a query.

When I have an issue with a calculation that I want to troubleshoot, I
generally open the datasheet view of the report's record source and copy all
the records to the Clipboard. I then paste them into Excel so I can "play"
with the data to find my error.
 
Back
Top