Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculation - Round Down!

Status
Not open for further replies.
Golfprocfc26

Golfprocfc26

Technical User
Jan 26, 2002
2
US
I have a calculation field that needs to be returned as a whole number. The challenge is, it is a calculation of a whole number and a percentage (Ex: 15 * 50%) this = 7.5 but I need it to round down to 7. Is this possible and how do you do it. This is driving me crazy!
Thanks
 
Sort by date Sort by votes
In layout mode click on your field,
goto format - number
and format the field like you want.

HTH

John
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Spac3man
  • Locked
  • Question
Invoice calculation question
Replies
4
Views
167
JeanW
JeanW
Marcs41
  • Locked
  • Question
Script Calculation error
Replies
1
Views
86
Marcs41
Marcs41
tbyrd1969
  • Locked
  • Question
Import record info from one table into another as a drop down list
Replies
7
Views
177
JeanW
JeanW
ddeblois
  • Locked
  • Question
Export a calculation field
Replies
2
Views
100
haitianfella
haitianfella
haitianfella
  • Locked
  • Question
color calculation
Replies
4
Views
129
TStriker
TStriker

Part and Inventory Search

Sponsor

Back
Top