aliquis Posted June 23, 2007 Posted June 23, 2007 I want to display a field containing the average value of a field across multiple records. So the obvious thing is to use a summary field set to calculate the average. But the displayed average defaults to 7 decimal places and I would like to reduce this to 2. I don't think you can do this using a summary field (can you?) So the obvious alternative seemed to me to set up a calculation and then use the Round function. Surely this must be straightforward, but I can't work out how it can be done. Sure I can get what I want using more than one field, but is it possible to display a rounded average using just a single field?
Genx Posted June 23, 2007 Posted June 23, 2007 When the field is on the layout, click it, go to format -> number and set up how you want it to look there.
Recommended Posts
This topic is 6421 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now