RyanN Posted April 21, 2005 Share Posted April 21, 2005 I have created a field called ....Pcs. Per bar. Here is the String Round ((Bar Length {ft}:*12 - Bar End:-Facing Stock:)/Length of Part:;1) I would like to always Round down to the nearest whole number even if the calulation is closer to the next higher Whole number. Example: 13.899 I would like to round to 13 as a return. Please Help Ryan Link to comment Share on other sites More sharing options...
Ender Posted April 21, 2005 Share Posted April 21, 2005 Try the truncate() function. Link to comment Share on other sites More sharing options...
comment Posted April 21, 2005 Share Posted April 21, 2005 Try the Int () function. Or, if you're rounding a result of a division, use Div () instead. Link to comment Share on other sites More sharing options...
FileMakin' Tom Posted April 21, 2005 Share Posted April 21, 2005 Or use the Abs function which returns only whole numbers Link to comment Share on other sites More sharing options...
comment Posted April 21, 2005 Share Posted April 21, 2005 Abs() returns the absolute (positive) value of a number, whole or fractional. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.