Jump to content

Help with a calculation


This topic is 6573 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have 2 databases. One database has scores for 800 people. I have a summary field which averages the scores for different groups. I have to know how to round the numbers in a summary field to get a result from the second data base.

My other data base has groups of numbers. For example if a group would get a 275 the raltionship with the other database should return 91. I have all the numbers in the second database, but they are all whole numbers. My first database always returns an average score with a decimal.

so when I get an average from database 1 of 275.51 it will not return the desired 91.

Do I set another field to round the average before the summary?

Any ideas???

Thanks

Lester

Link to comment
Share on other sites

Ok, here is what you do.

1st in your number format it as of course a number and then click decimal and make it 0 (Zero)

If that doesn't work your can try either the Truncate function or the Round function. I prefer the Truncate. Formatting the number should work though.

Link to comment
Share on other sites

This topic is 6573 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.