Formatting a caculated field (1 Viewer)

srm7028

New member
Local time
Today, 21:44
Joined
Aug 17, 2002
Messages
6
I have a top hits table with a hits and at bats field . In order to get the batting average hits/atbats but the total i am am getting is too long i need to round it or specify somehow that i only want 3 spaces after the decimal .360 instead of .3604759837458. I have searched help and everywhere i could find on the net. Can it be done and if so how?


Thx, Sean
 

R. Hicks

AWF VIP
Local time
Today, 15:44
Joined
Dec 23, 1999
Messages
619
Int(UnRoundedValue * 10 ^ 3 + 0.5) / 10 ^ 3

HTH
RDH
 

srm7028

New member
Local time
Today, 21:44
Joined
Aug 17, 2002
Messages
6
Thx anyway

Didnt work
 

Users who are viewing this thread

Top Bottom