I am using datatable.comput to calculate the avg of a data column. The data column's datatype = integer, so it returns a integer avg value as well. Can i make it to return double value?
View 3 RepliesI'm trying to alter the existing number formatting in my company's application to make it more readable for international users. This is a stock trading application, so most stock prices come in with numbers precise to 2 decimal points, like so-> 17.23 We could also get ticks in that have precision out to 4 decimal points, so a penny stock might be 0.0341. The original string format that we were using for stocks was "#,##0.00##" Which would give us the format we wanted (essentially trimming '0's). The problem here is the ',' and '.' are forced onto the user, where in many other countries the thousands separator is '.' and the decimal point is ','. Boss man doesn't want to use "N4" for all numbers, even though this would resolve the globalization issue. Is it possible to have a globalized custom string format?
Other options besides writing some middle man code to internationalize numbers formatted the original way or another string.format method?
What is the cleanest, most readable way to String.Format a decimal with the following criteria
start with a sign symbol (+ or -)
a fixed number of fraction digits
no decimal separator
right aligned
pre-padded with "0"'s
format number to hower many number on left of decimal and 1 decimal without rounding
View 2 RepliesI need to round the result from compute.8/19, how can i round this result to two decimal.Is there any symbol i can use for compute function to recognize the rounding format, because not must be two decimal,sometime may one or in integer?
View 3 RepliesIn window textbox, I'd like to just allow 2 decimal points only. I could set text box only numeric but don't know how to limit 2 decimal points.[code]...
View 3 RepliesI want two decimal points value. I have used this code
lblNo.Text = Math.Round(CDec(txtNo.Text + (txtNo.Text * 0.2)), 2).ToString()
If i have value as 1.32 then its ok but if i have value like 2.3 it shows 2.3 but i want value as 2.30 How can i get this value.
this function enables you to calculate a full arithmetic calculation , as 5*(3+2)+6 , but : it's limited with (+,-,*,/) signs . is there any way to add a support for the another signs (like : !,sin,cos,tan,root,^,log and another signs) to give the user the ability to calculate a full calculation including the other signs which cannot be calculated within the compute.datatable function ?
View 2 Repliesi have this code in vb and i want to know how to make it to add decimal points
Dim a, b As Integer
a = CSng(TextBox1.Text)
b = CSng(TextBox2.Text)
Dim result As Single
result = a + b
Lb_sum.Text = result
for example if i add 4.2 + 4.4 its show 8 instaid of 8.6
How to eliminate decimal points in VB.net.what kind of function should i use.
For example, i have number x= 23.13 i only want to show x= 23 and if i have another number x=23.89 i also only want to show x= 23
[code]...
How to allow two numbers after decimal points ?
View 1 RepliesI do have the following problem extracting records from a datatable, based on date.
I am using Datatable.compute to sum the relevant rows, at least I'm trying to!
CrTot is a variable of type double
BankTrans is a datatable
dteRecDte is a datetimepicker component
CrTot = BankTrans.Compute("sum(bank_amount)",
"bank_amount > 0 And date_bank_reconciled <="
& dteRecDte.Value.Date)
doing the sum calculation on it's own works properly. I now need to check that the date of the "date_bank_reconciled" field is less than or equal to the value of the date entered in the datetimepicker "dteRecDte.Value.Date", so that only rows with a date either less than or the same as that in the datetimepciker are returned.
I have an app that contains a DataTable that I must summarize. In that table is a Status column (also the index order) and I want to write a loop in which I compute the count for each status. So I wrote my loop and tried to use the compute function of the Datatable class, but I cannot get it working due to some constraints - specifically this...
[Code]....
You can see what I am doing here is grabbing the string value of the Status column, and then trying to get a count of how many records have that Status. My ultimate goal was to cycle the Table and count each time the status changes. But the error I get has to do with where I store the Status in a String, and then issue the second parameter on the Compute function which contains a variable (sumString) and this is where Compute is crashing - and of course, I can see why - my Status is not literal and thus not in quotes.
Generally speaking, is there any way to manage this kind of thing? In my (very) old FoxPro days one would use a macro such as "Status = &sumString" and VFP would translate sumString to its literal. I have never discovered a way to do that in .NET.
I need help with this line of code: Me.avgsalespricetxt.Text = Me.dtsold.Compute("AVG(Convert([Selling Price]),'System.Int32'))")
Here is all the code i have so far, I need to Average a column in my datatable from what i have read "Compute method supports expressions and they support CONVERT function that you could use inside of the expression."
[Code]...
I am working on a program where specific strings are being read from a file and displayed in a listview. Some of the strings represent money values though the file has no decimal points. I would like to add a decimal point before the last 2 digits of prices, quantities, and freights when displayed in the listview (not add two decimal places but actually insert the decimal point into the string). I would like to be able to keep most of the code I already have though, and I have no clue how to accomplish this. Here is the code I am using to fill the listview:
VB2010
Public Class Form1
Dim dates1() As String[code].......
I have a double value like 3768.595863. if i round this value then i will get 3768.596 but i want 3768.595.how can i get that?please reply.
View 7 RepliesI've found plenty of examples of accepting numbers only in a text box, but the code won't allow decimal points. This is crucial because I'm dealing with US currency.
01.' Force numbers only in a text box
02.' place this in the 'Keypress' event of a text box
03.
[Code]....
How can I change the IF statement to accept the ascii code of decimal points? Then... how can I make sure the user doesn't enter 354.5.3535.5.0 as a number? Is there some sort of built in library in VB that has a pattern matching for US currency or do I have to write it myself?
Why my math keeps getting rounded to 0 decimal points by default?When I do this I get return value of 1
Private Sub Button4_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
Dim numb1 As Integer
numb1 = 100 / 78
MsgBox(numb1)
End Sub
How to get that value up to two decimal points (like 0.00)?
I need the application version as an integer with decimal points eg: 1.2 At the moment I'm using:
Dim CurrentVersion As Integer
CurrentVersion = My.Application.Info.Version.Major & My.Application.Info.Version.Minor
which just gives me 12.
What i'm trying to do is compute whether an integer number is prime or not. The program performs this analysis for all odd numbers from 3 up to an input integer limit, for example 100. If the integer in the range 3 to limit is prime, a message stating so is printed. Otherwise, a message is printed that lists at least one other integer divisor. The output for each analyzed number consumes one line of text.
A sample output is shown below:
Limit is 100:
Number 3: is prime
Number 5: is prime
Number 7: is prime
[CODE]...
I understand I need to use loops, boolean functions, vbmath(), strings and multi-line out via concatenation. So I can put this is words how I think it should be done but not so great putting the code together
Test all integers up to the SQRT of the number (100)
limit = math.sqrt(100) + 1
Followed by 1 For statement
For c = 0 to 100 step 2?
And an If statement
If ......
result = false
I want to convert numbers from 0 to 15 like that
[Code]...
Problem is that when we convert 2 to binary number it gives only 10 in binary, but i want to convert 2 to 4 bit binary number 0010.
I am calling the function below from an Excel spreadsheet and the conversion from hex to decimal using the VAL function in the "manufacturer" variable below is coming back with a negative value. The VBA edition is 6.5.
Public Function decMEID(ByVal sKey As String) As String
Dim manufacturer As String
Dim serial As String
[code].....
I want to calculate variance of a col in my datatable object. If i apply datatable.compute(Var(...)), i gives a negative result. Variance can't be negative. And it I just apply it to half of the data, it works fine. Does datatable.compute has a limited capacity?
View 7 RepliesI have a datatable with 2 columns named TimeStamp and value. After I populate the table with rows, I am using the table's compute method to get the max value like this....
MyTable.Compute("MAX(value)", Nothing)
Is there is a way to get the row (or more specifically the TimeStamp value) where the max was found?
im having trouble understanding this question for a homework assignment. I need to write the PSEUDOCODE for the following scenario, but i got no idea about how to convert a hexadecimal number to a decimal number..You are required to input a two digit hexadecimal number eg. 3f (digits can be entered separately) and calculate the equivalent decimal number. (note the decimal number will be between 0 and 255) . output the decimal number
View 1 RepliesTo allow a textbox to contain "15" or 15.5" as numbers nothing else...I figured that ^\d+$ works for numbers but can't get decimals to work also?
View 1 RepliesI did a simple screen saver just using a random number generator for the x and y points of a picturebox and it's ok but I thought I may try to snazz things upwith the image floating on the screen?
View 3 RepliesI am building a program that calculates the number of books by points.Ex: 1-3 books read are worth 10 points, 4-6 are worth 15 and > 6 are worth 20. The issue I'm having is getting it to calculate the the first 3 books, the 2nd 3 books and then the > 6.Ex: User inputs 8 books read. It should display 115 in the label.
1. I'm using an If statement (should I be)
2. Could I use a decimal for the > 6?
Ex: intTotalNumberOfBooks = (intTotalNumberOfBooks * intFirst3Books) *#D
I know this is something simple and it's out of VB 101, but it is my very first programming class and my professor uses a copy paste method during class.
I have a column: {2,2,null}. If i use datatable.compute to compute the avg of this column, will it return 2 or 1.66? In another word, will this function ignore the null value?
View 4 RepliesI need to display a grade based on the number of points entered. store the min and grade in a 2d array here's my code that I have currently:
Dim strGrade(,) As String = {{"0", "F"},
{"300", "D"},
{"350", "C"},
[code]....