Rounding up Control

[stretch66]

Am sure there is a simple solution to the people that know.....which isn't me!
But I have a text box on a report to calculate % of total and don't know how to Round it up or display the total?

The Text box is:

=([TotalTemp])/([GrandTotal])*100

Tried =Round([TotalTemp])/([GrandTotal])*100 & "%" with no joy and have quite a few of these to implement.

 

[neileg]

Format the text box to Percentage. Then make your formula
=Round([TotalTemp]/[GrandTotal],2)

This should give you the result to two decimal places.
You can play around with the value in the Round formula and the number of decimal places in the text box properties to get whatever display and precision level you need.

 

[Mile-O]

Can't you just set the Format property to 0%