No announcements
Found 1632973 threads
-
1 VotesTo Round up Fraction Amount Values in Rupees.
Use the Math.Ceiling method: Dim d As Decimal = Math.Ceiling(1687.50)Answered | 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
-
1 Votes
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 = ...Answered | 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 -
1 Votes
Rounding decimals
Be aware that what you are doing is not rounding.Answered | 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 -
14 Votes
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 ...Answered | 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 -
1 Votes
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 ...Answered | 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 -
0 Votes
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().Answered | 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 -
2 Votes
ROund off Decimal
--or this: select num, (try_cast(round(num,0) as decimal(10,2))) ,round(try_cast(num as ...Answered | 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 -
0 Votes
help rounding amounts in select statement
I'm getting amounts in a SELECT statement and splitting those amounts up.Answered | 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 -
3 Votes
Round to decimal isn't working
Hi linkit, After rounding the decimal, you have to again set it back to textbox like as below.Answered | 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 -
0 Votes
How to control decimal rounding on Reports.
##" to round the number to 2 decimal places without trailing zeroes.Answered | 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 -
0 Votes
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); ...Answered | 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 -
0 Votes
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 ...Answered | 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 -
1 Votes
Rounding Off a decimal number
Sid, Take care that default in .Net is Banking Rounding (to even).Answered | 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 -
1 Votes
Decimal Rounding Issue
try : select cast(Round(99.999999937,2,1) as decimal(38,2)) Best regardsAnswered | 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 -
2 Votes
How to round off to two decimals?
How did you do it without being a moderator?Answered | 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 -
2 Votes
Truncate decimal without function
I assume that "without function" you mean with "without user-defined function".Answered | 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 -
0 Votes
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.Answered | 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 -
1 Votes
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.Answered | 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 -
1 Votes
problem in rounding decimal in VB.Net
http://en.wikipedia.org/wiki/Rounding In VB is standard banking rounding used.Answered | 4 Replies | 3332 Views | Created by dg78 - Thursday, October 3, 2013 9:12 AM | Last reply by dg78 - Thursday, October 3, 2013 5:50 PM -
2 Votes
two decimal rounding problem in SQL Server
Hi Manish, According to your description, it seems that you want to display two decimal points as the rounding value.Answered | 11 Replies | 2868 Views | Created by manishcal16PPS - Monday, September 1, 2014 9:31 AM | Last reply by Katherine Xiong - Monday, September 8, 2014 6:56 AM - Items 1 to 20 of 1632973 Next ›
No announcements
