Option to remove the rounding function?

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:49 PM GMT


When creating a formula init automatically rounds, is there an option to just drop the decimals with out rounding? example: if my answer is 123.5 I want it to read 123. But I dont want to round down because I want 123.3 to read 123 also.


Sure. Use the TRUNC function to truncate numbers (chop off the decimal points).



©2024 eLuminary LLC. All rights reserved.