Rounding up in report??

[JNana]

I have a report based upon a query. When I run the query, my column of
numbers is .01 cent short. I do not see how to change the query to round
up, so I went to properties in the report and made sure that the decimal
places were set to 2. It was originally auto. Neither auto or 2 decimal
places caused the system to round up.

Can you give me some guidance in setting the format, please?

JR

 

[Marshall Barton]

I have a report based upon a query. When I run the query, my column of
numbers is .01 cent short. I do not see how to change the query to round
up, so I went to properties in the report and made sure that the decimal
places were set to 2. It was originally auto. Neither auto or 2 decimal
places caused the system to round up.

Common mistake by non-mathematical people. The total is the
more correct value, while your pencil and paper calculation
is in error because you are not seeing the complete
individual numbers.

SInce most people don't care about real precision and just
want the numbers to be consistent, you can use the Round
function in the sum calculation. e.g. =Sum(Round(field,2))

 

[JNana]

Thanks for your response. However, I get an error as follows:

"The expression you entered contains invalid syntax."
My expression is: =Sum(Round(Essett Payment,2))

Did I misunderstand?

 

[Marshall Barton]

Thanks for your response. However, I get an error as follows:

"The expression you entered contains invalid syntax."
My expression is: =Sum(Round(Essett Payment,2))

That's because you are not following best practices by have
a space or any non-alphanumeric character except underscore
in you field's name. You should eliminate these oddities
and use "ordinary" names such as EssettPayment or even
Essett_Payment.

The workaround is to enclose the name in [ ]

=Sum(Round([Essett Paymen], 2))

 

[JNana]

Thank you

Thanks for your response. However, I get an error as follows:

"The expression you entered contains invalid syntax."
My expression is: =Sum(Round(Essett Payment,2))

That's because you are not following best practices by have
a space or any non-alphanumeric character except underscore
in you field's name. You should eliminate these oddities
and use "ordinary" names such as EssettPayment or even
Essett_Payment.

The workaround is to enclose the name in [ ]

=Sum(Round([Essett Paymen], 2))