No announcements

### To Round up Fraction Amount Values in Rupees.

Use the Math.Ceiling method: Dim d As Decimal = Math.Ceiling(1687.50)
| 3 Replies | 414 Views | Created by Atif Zafar Khan - Tuesday, February 24, 2015 11:24 AM | Last reply by Atif Zafar Khan - Tuesday, February 24, 2015 12:12 PM

### Round a decimal number

This is how I do it, eg for 3 sig fig (including a trailing zeros after decimal - good for currency) num = Math.Pi round = ...
| 1 Replies | 426 Views | Created by BluStars - Wednesday, July 26, 2017 8:09 PM | Last reply by litdev - Wednesday, July 26, 2017 8:49 PM

### Rounding decimals

Be aware that what you are doing is not rounding.
| 4 Replies | 1051 Views | Created by Paul Pitchford - Monday, November 19, 2012 11:43 AM | Last reply by Cor Ligthert - Monday, November 19, 2012 12:28 PM

### Round Off float value to 2 decimal places

See, I need to get the value as float. :( I've tried 'SELECT CAST(ROUND(178.6999,2) AS NUMERIC(12,2))' I'm getting the value as ...
| 12 Replies | 148755 Views | Created by Vipin_PC_04 - Thursday, June 27, 2013 9:52 AM | Last reply by Vipin_PC_04 - Friday, June 28, 2013 4:21 AM

### Import decimal truncates instead of rounding

It is obvious that the General format rounds values up to the obvious scale with the least decimal places, but since all of the cells have different scales, I am ...
| 5 Replies | 3783 Views | Created by duanewilson - Monday, February 6, 2012 8:44 PM | Last reply by ArthurZ - Monday, February 6, 2012 9:41 PM

### Rounding in SQL on decimal Placees

There is no parameter value to instruct the engine to round up Because of that, I have had to solve this problem, I would use FLOOR() and CEILING().
| 9 Replies | 5556 Views | Created by Krish Tucker - Thursday, January 12, 2012 2:41 AM | Last reply by tokash - Thursday, January 9, 2014 4:22 PM

### ROund off Decimal

--or this:  select num,   (try_cast(round(num,0) as decimal(10,2))) ,round(try_cast(num as ...
| 2 Replies | 879 Views | Created by Rajm0019 - Tuesday, November 26, 2019 3:38 PM | Last reply by Jingyang Li - Tuesday, November 26, 2019 3:47 PM

### help rounding amounts in select statement

I'm getting amounts in a SELECT statement and splitting those amounts up.
| 5 Replies | 556 Views | Created by Phigl - Monday, April 22, 2019 6:27 PM | Last reply by Erland Sommarskog - Wednesday, April 24, 2019 9:35 PM

### Round to decimal isn't working

Hi linkit, After rounding the decimal, you have to again set it back to textbox like as below.
| 5 Replies | 5260 Views | Created by linkit - Friday, February 25, 2011 8:14 AM | Last reply by ksvimal - Monday, February 28, 2011 8:53 AM

### How to control decimal rounding on Reports.

##" to round the number to 2 decimal places without trailing zeroes.
| 2 Replies | 2988 Views | Created by APradeep - Monday, October 17, 2011 6:16 AM | Last reply by JLHui - Monday, October 17, 2011 6:39 AM

### Rounding decimal to whole number.

To add to jochen`s post: to round number use Round method of Math class: decimal z = some dec value z = Math.Round(z, 2); ...
| 2 Replies | 2223 Views | Created by ecarter202 - Sunday, September 2, 2012 7:57 PM | Last reply by Mitja Bonca - Sunday, September 2, 2012 8:35 PM

### Preventing Rounding in DECIMAL Arithmetic

In order to get the result of the divide to be decimal(38,15) so no conversion is required, you would have to do the very ...
| 13 Replies | 5146 Views | Created by Kalman Toth - Tuesday, August 3, 2010 9:49 PM | Last reply by Kalman Toth - Wednesday, August 4, 2010 5:48 AM

### Rounding Off a decimal number

Sid, Take care that default in .Net is Banking Rounding (to even).
| 4 Replies | 669 Views | Created by Sid Williams - Saturday, May 23, 2015 1:55 PM | Last reply by Solitaire - Saturday, May 23, 2015 4:14 PM

### Decimal Rounding Issue

try : select cast(Round(99.999999937,2,1) as decimal(38,2))    Best regards
| 4 Replies | 2916 Views | Created by Farrukh Lala - Monday, January 30, 2012 1:52 PM | Last reply by i_h - Monday, January 30, 2012 4:06 PM

### How to round off to two decimals?

How did you do it without being a moderator?
| 11 Replies | 1007 Views | Created by Joseph17 - Monday, August 15, 2016 3:37 PM | Last reply by Mauricio Feijo - Thursday, August 18, 2016 8:40 PM

### Truncate decimal without function

I assume that "without function" you mean with "without user-defined function".
| 3 Replies | 2020 Views | Created by Kenny_Gua - Monday, September 18, 2017 8:50 PM | Last reply by RyanAB - Monday, September 18, 2017 10:12 PM

### Decimal Value looks funny

If you need to avoid the effects of these tiny rounding errors, you must round the results of your calculations to the desired number of decimal places.
| 15 Replies | 512 Views | Created by GestionControleur - Friday, January 23, 2015 9:59 AM | Last reply by GestionControleur - Monday, January 26, 2015 10:20 PM

### function to round 3 decimals

In VBA Int(x * 100 + 0.9) / 100 This will round 0.874 to 0.88, 0.871 to 0.88, but 0.8709 to 0.87.
| 2 Replies | 2597 Views | Created by palermo_software - Friday, June 8, 2012 8:34 PM | Last reply by evohnave - Monday, June 11, 2012 12:06 PM