Percentages (2003)

Topic

New Reply

I have two fields on a query which are causing problems when rounded up. The figures are in two seperate queries, to give me a percentage. One is 83.06 and the 0ther is 82.63. When rounded up, they both are 83, which is right. I have set these as percentages on a report which compares the two, and states whether the result has gone up or down or no change. The result in this case should be no change, but I’m getting down.

Reply | Quote

Replies

Keep in mind that the display format does not affect the underlying data. If you display 83 on your report, the actual value is still 82.63 (or 83.06). How are you comparing the values?

Reply | Quote

I’m comparing on the report using a control with =IIf([PercentageLast]>[PercentageThis],”Down”,IIf([PercentageLast]<[PercentageThis],"Up","No Change")) as the formula.

Reply | Quote

Try

=IIf(Round([PercentageLast],0)>Round([PercentageThis],0),”Down”,IIf(Round([PercentageLast],0)<Round([PercentageThis],0),"Up","No Change"))

This assumes that the PercentageLast and PercentageThis columns return values between 0 and 100. If they are real percentages, i.e. values between 0 and 1 (=100%), use Round(…,2) instead.

Reply | Quote

Getting ‘Invalid syntax’

Reply | Quote

You probably introduced a typo somewhere. Check carefully, the expression as posted should work.

Reply | Quote

There must be an error elswhere then. I’ve typed it in twice, and even cut and pasted from the email into the report, and still get the error message.

Reply | Quote

Without seeing the database, it’s impossible to say what causes it.

Reply | Quote

The syntax is correct (I tried pasting it into a query). Be careful that you are pasting all and only that into the control source of the control in your report.

Reply | Quote