Get Correct Percentage
I've always been looking for the best way to get an accurate percentage
statistics.
For example, in a election scenario:
Person A gets 33 votes
Person B gets 33 votes
Person C gets 34 votes
Person D gets 35 votes
Total votes = 33 + 33 + 34 + 35 = 135
Percent for A = 0.244.... = 0.24 = 24%
Percent for B = 0.244... = 0.24 = 24%
Percent for C = 0.251... = 0.25 = 25%
Percent for D = 0.259... = 0.26 = 26%
Then add up the percentage values: 24 + 24 + 25 + 26 = 99
(where it should be 100)
So, does anybody have a way to get around this problem? How should I
calculate the percentage for each person so that the percentage will add up
to 100 in the end?
View Replies
ADVERTISEMENT
I wrote a survey script but I had problem with the percentage.If 5 persons answers to a question YES and 3 answered NO, how can I get the percentage of each answer (YES & NO)?
View Replies
View Related
this is what im doing
itotalprice = (setfares and other items)
im now dealing with the 5% service charge for credit card payments.
the service charge will be 5% of itotalprice
how can i calculate that.. it will be something like..
surcharge = 5% of itotalprice
fullprice = (itotalprice + surcharge)
View Replies
View Related
Our store software currently displays the total amount saved (the list price minus our price) for every product using the code below:
'Calculate "YouSave"
If Product_ListPrice > 0 Then
Product_YouSave = Product_ListPrice - Product_LowestPrice
End If
I, however, would like to also diplay the percentage saved next to the amount saved. I tried using the code below but it won't work. Can someone help me out?
'Calculate "YouSavePercent"
If Product_ListPrice > 0 Then
Product_YouSavePercent = ((1 - (Product_LowestPrice / Product_ListPrice) * 100)
End If
View Replies
View Related
I would like to subtract a fixed percentage (15%) but can't seem to get the syntax right.
Output:
Item: Nougat Retail Price: $3.99 Discount Price: 15% Total: ?
Code:
strChocoItem1 = "Nougat"
strRetPrice1 = FormatCurrency("3.99")
strDiscPrice = FormatPercent(".15")
strTotal = ?
I've tried lots of different ways to reach the total but failed every time. I want to subtract the retail price from the discount price using a fixed percentage. Is this possible?
View Replies
View Related
I have a recordset iterating through and dumping out to the screen a series
of percentages, using the precision 5 and numericscale 2 etc.
When I dump them to the page some of the number are missing a trailing
zero - ie, 4.7
What I would very much like to do is add this back on - is there an easy way
to format this with a huge load of If...Then's to produce the same affect?
View Replies
View Related
I'm using asp to write an asp page, but I'm having a problem when it comes to closing the written asp script
<%
countFileOpen.write("<% aspCount=5 %>")
%>
how do I escape this character?
View Replies
View Related
I need to build a script where in the source code i enter a number and when the page is executed it shows a percentage.
Here is an example of what i'm trying to do
88.83 / 12 = 740%
and the 740% is the only visable thing on the page
View Replies
View Related
I have to calculate the percentage of an X amount depending on the Quarter of the year. It's driving me crazy, I can't figure out how to do it. Am I missing something. If someone registers the 1st quarter then the price is the full 1200. f the registration occurs the 2nd Quarter, then it is 25% less that rthe full amount. The 3rd is 50% less and the 4th is 75% less.
the amount is 1200
the Quarters of the year = 4
The regristrant is 1
(1200/4)*100 ?????
View Replies
View Related
Well my goal is simple. On my site we show "You save: $**.**" but I want that to say "You save: $**.** (**%)."
The database for our store stores the list price, and our price. The store calculates the you save price... so it should be easy to calculate the saved percentage as well. Here's the code that calculates up the "You save" currently on our website: Code:
View Replies
View Related
i'm sure there're no post about this in asp forum.Any idea how do I show the percentage number for the matching result.
example :
Your search for xxxx :
1. item 1 98%
2. item 2 86%
3. item 3 75%
View Replies
View Related
I want to convert a number to percentage, is there any built-in function for this?
View Replies
View Related
I am trying to parse this response.write string but its coming up with a formatting error - can someone please tell me where I'm going wrong?Code:
Response.write ("<input name=""URL"" type=""text"" value=""http://www.evolvewebsitedesign.com/news-indiv.asp?news=" & rssite("News") & ""/>")
View Replies
View Related
I am needing to response.write a variable within a snippet of Javascript.
My Javascript code that I need to response.write with the variable is below:-Code:
response.write ("imageArray[ImageNum++] = new imageItem(image_dir + ""variable here"");")
I can response.write the static Javascript string fine. The problem arises when I try and state a variable into where it says, 'variable here'
The variable I need to include is
Code:
rs.Fields("ImgURL")
Would someone please be able to show me the correct formatting for this Javascript string which includes the variable.
View Replies
View Related
My asp syntax is very lacking, it seems the double quotes that have been
done by me are not what asp is looking for. Anyone that could correct my
faulty thinking would be thanked.
View Replies
View Related
how to display correct time according to user timezone
i want to do an online meeting let say schedule meeting at 1:00pm server time, how do i display the correct time for users in their local time
View Replies
View Related
I have a form where users can enter search criteria for various products.
now, if this form has 2 fields, colour and size (it wil have more but I'm
assuming the the principle for two fields will be the same for ten fields)
what would be the correct syntax for performing a query where the user
didn't enter a criteria for both fields?
the search string would be
strSQL = "SELECT * FROM products where colour = " & "'" &
request.form("searchstrcolour") & "'" & "AND size =" & "'"
request.form("searchstrsize") & "'" & " ORDER by price"
so if the user selects blue and large, thats fine
but what if the user only selected say blue and didn't bother with the size?
is there a wild card that I could use?
View Replies
View Related
can someone explain to me the diffrence between the 2 below and why one works and the other one doesnt.could you also explain what each part of the correct version is doing because i dont really no.
INCORRECT
sql = "SELECT * FROM userlogon WHERE (username)=' "& (username) & "' AND (password)=' " & (password) & " ' "
CORRECT
sql = "SELECT * FROM [userlogon] WHERE [username]=' "& username & "' AND [password]=' " & password & " ' "
View Replies
View Related
is it active server pages or application service provider .which is correct
View Replies
View Related
chk whether the code is correct? For the update date
SQL_query1 = "update Activity_Status set TotalTime = '" & Request.Form("time") & "', Score = '" & Request.Form("QuizScore") & "', Activity_Name = '" & Request.Form("QuizType") & "',ActivityDate = '" & "#" & Date() & "#" & "' where UserID ='" & Request.Form("username") & "' and Activity_Name='" & Request.Form("QuizType") & "'"
View Replies
View Related
i need to delete some values which have dates that are less than today's from a table. The date is in another table so i joined the two tables together and gave a clause
I did this:Code:
DELETE *
FROM RMASerial, Sold
WHERE RMASerial.SoldID=Sold.SoldID
And Sold.Warranty_date<Date();
But that doesnt seem to be working.
View Replies
View Related
I have a few pages that require login to access. Assuming a user clicks a
link containing a variable trying to access a password protected page. That
user is redirected to the login page. After login, he's brought to a "logged
in" page. How do I retain the original link he clicked and instead of
redirecting to a logged in page, he's redirected to the page he originally
requested?
View Replies
View Related
Im trying to make a client area on my website and an not sure on how to go about editing clients details.When the client logs in they are brought to a menu where they can update there record. How can i get the appropriate record from the database so they can update there details?
View Replies
View Related
I have a database which stores information,I have a page which has links to each of the rows in the database and to search by each row it has its own unique ID. The problem I am having is only one row keeps getting returned from the database.I have an access database and using ASP. I think the problem could be with the SQL statement.
SQL = "Select * FROM monitoring where monitoringID = & request('ID') &"
View Replies
View Related
On asp.net, How can we programmatically verify whether the UserName and Password is Correct? and when i close the application directly and open again, is still in lon in status.?
View Replies
View Related
i have this function in asp that should return false when a match is not found, but it keeps returning "exception occured". How do i go about getting this thing to work properly.Code:
public function isValidUserName(byVal user_name)
dim sqlComm
sqlComm = "SELECT USERNAME FROM S_USER WHERE USERNAME = '" & user_name & "'"
set oRs = oConn.Execute(sqlComm)
' if a match is found then return true
if oRs("username") = user_name then
isValidUserName = true
else
isValidUserName = false
end if
end function
View Replies
View Related
how to display correct time according to user timezone. i want to do an online meeting
example: let say schedule meeting at 1:00pm server time, how do i display the correct time for users in their local time are there any tutorials to do this.
View Replies
View Related
I have set with lcid value. but i am not able to overcome my nt server regional setting. Actually i want a date in mm/dd/yyyy. But i get date as mm/dd/yy. How to ensure that i shall always get correct format irrespective of os or regional setting.
View Replies
View Related
I'm looking at another developers code and I'm now confused about the correct way to close a database connection and destroy the object. I would normally do it this way: Code:
View Replies
View Related
I'm getting an error on my ASP page:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'StoreFileIntoField'
I assume - 99.5% - the error is generated because of worng value types,
I attemp to pass from my ASP/VBScript page to the VB/DLL function.
My relevant ASP/VBScript Code:
View Replies
View Related
I'm getting an error on my ASP page:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'StoreFileIntoField'
I assume - 99.5% - the error is generated because of worng value types,
I attemp to pass from my ASP/VBScript page to the VB/DLL function.
My relevant ASP/VBScript Code is:
View Replies
View Related
I want to insert a value into the database.The values are obtained from textboxes.When i try to insert i am ending up with the error:
No value given for one or more required parameters
The part of the code is:
new1 = Request.Form("new")
tab = request.form("stcode")
<%sql="INSERT INTO movable1 (" & TAB & ") VALUES(" & new1 & ")"
conn.execute(sql)
if err<>0 then
response.write("Error")
else
response.write("The " & new1 & " was added under " & tab & ".")
end if
%>
the field is a numeric field.Could anyone figure out what is the fault?
View Replies
View Related
I am having much difficulty having a form write to a DB... I am an ASP newbie and am noticing the errors are pointing to this script... currently this script is producing no error messages but when a user selects one of the chk options in the "Nominator code" section of my code, it won't write to tblNomCommVotes. Code:
View Replies
View Related
