DataSource Controls :: Calculate Percentage From Table?

Jun 22, 2010

I have a table that contain the votes(publicVotes) against each contestant. Now what i am trying to do is to calculate the percentage of votes each contestant recieved according to the column SchedularID. how i can get it done and would it be easy to user store procedure or view?

ID
ContestantID
SchedularID
PublicVotes
JudgesVotes
1
4
2
4
NULL
2
2
1
1
NULL
3
3
2
2
NULL

View 10 Replies


Similar Messages:

How To Calculate The Percentage Of Scheduled Hours

Aug 30, 2010

I have weekly wise scheduled hours of each employee and no of days scheduled for each employee,now i need to calculate no of employees scheduled less than 24 hours,no of emp's scheduled b/w 24 and 48 hrs and emp's scheduled more than 48 hrs in percentage for fisrt week,second week,3rd week and 4th week.

Like this

SCheduled Hrs 8/1/2010 8/8/2010 8/15/2010 8/22/2010

Less tha 24 hrs 5% 5% 5% 5%

b/w 24 and 48 hrs 4% 5% 5% 5%

>48 91% 90% 90% 90%

View 5 Replies

Web Forms :: Calculate Exact Number For Given Percentage In C#

Jan 30, 2013

I need to deduct the amount for the given percentage but i am having small difference in the calculatiion

I do the following

  int input = 6065;

  int result = input * 60/100;

The result i got is 3657.  But the actual result is 3657.6 and i need to round up so i need to get

3658.

View 1 Replies

SQL Server :: Cannot Reference Column Names To Calculate Percentage

Feb 15, 2011

I have the following SQL:

SELECT SRFILE_1.SRCONMAE, COUNT(LBWF_1.Incidentx) AS SLAFailed,
(SELECT COUNT(Incidentx) AS Expr3
FROM LBWF AS LBWF_2) AS TotalCalls
FROM SRFILE AS SRFILE_1 INNER JOIN
LBWFAS LBWF_1 ON LBWF_1.Incidentx = SRFILE_1.SRONUMBER
WHERE (LBWF_1.KPIFailx = '1') OR
(LBWF_1.Chargex > '0.00') OR
(LBWF_1.LChargex > '0.00')
GROUP BY SRFILE_1.SRCONMAE

What I'm trying to do is divide TotalCalls by SlaFailed and * by 100 into a new variable such as Percentage. However, everytime I try to select SLAFailed or TotalCalls I receive a 'Column Names do not exist' message.

Is there any way I can reference said values?

View 5 Replies

Web Forms :: In Crystal Report How To Calculate Total Marks Percentage

Apr 27, 2016

As i am trying to do crystal report task as it is aim is to calculate the Sum Of Subjects Marks And calculate the percentage ....I am not able to calculate the percentage.

View 1 Replies

Asp:table Width In Percentage Is Not Working?

Feb 10, 2011

I'm trying to get a table to look correct. When i use fixed width, the table is the size i'd like for it to be... but when i use %, it's like it's ignored.

Here is the code

<asp:Table ID="Times" runat="server" style="Width:100%;">
<asp:TableRow BackColor="YellowGreen">
<asp:TableCell Width="45%">
<asp:Image ID="imgImage" runat="server" />

[code]....

View 1 Replies

Forms Data Controls :: Calculate Total Time From A Record In A Table?

Dec 31, 2010

I tried with no succcess doing a search here on the forum for some answers or pointers. So here goes.

I would like to Calculate total time from a records in a table.

the Table we'll call it "Time Table" may have four rows IE.

Field1 Field2
IN 08:00:00
OUT 12:30:00
IN 13:00:00
OUT 17:00:00

I am trying to display these records in a Child gridview with a total. Is there any SQL that can total time like this? or any other way I can total this?

View 7 Replies

DataSource Controls :: Calculate SQL Datediff For All Records?

Jun 17, 2010

I am trying to write some SQL to populate a gridview.

The sql should print out 3 columns:

Name, County, LastCollection (the amount of days since the last collection)

I have previously calculated the amount of days since last collection individually like this:

[Code]....

But am stuck on doing it for more than 1 record to populate the gridview which should show all the records and their last collection date.

View 9 Replies

DataSource Controls :: How To Calculate 3 Days Average

Feb 26, 2010

how to calculate 3 days average

View 4 Replies

DataSource Controls :: Calculate The Slope Of A Dataset?

May 19, 2010

I have a certain report I want to make where I want to calculate the slope of a dataset(turnover column) following the formula:

SumXY-MeanY*SumX / SumXX-MeanX*SumX

In order to do that the X-range has to be an integer from 1 to the last datarow. In my report I get this exact number with the rownumber(nothing) formula. But it seems I can't calculate with it in the expression for the slope because it gives errors:

=(rownumber(nothing)-Avg(Fields!TurnOver.Value)*Sum(rownumber(nothing)))/ ((Sum(rownumber(nothing)*rownumber(nothing)-avg(rownumber(nothing))*sum(rownumber(nothing)))

View 1 Replies

DataSource Controls :: Calculate Repeated Chars In A String?

Jan 8, 2010

I have problem like to count the repeated chars from a string using sql server.Also i have used functions in sql server thats working fine.But i want the solution using a sql query...

[i have a column like ID,name,Secure_name],here 1 ,'kamal','welcome'.so findout 'e' howmany times repeated in a column secure_name.....

View 2 Replies

DataSource Controls :: Calculate Financial Year In Sql Server?

Jun 17, 2010

I need financial year in system date.actually i calculate financial year like below in VB code. [Code]....
i just like the same in sql server query.for example suppose my query like"select*from admission where std_code=1 and fnyr in (select finy in system date)"<---i need here.

View 18 Replies

DataSource Controls :: How To Calculate The Total Quantity Demanded By A Particular Customer

Mar 22, 2010

We have a demand system where customer can demand the quantity they want for a particular deal.

For each demand they submit, a new record is added to the DealDemandRequest table with the CustomerID, DealID, Quantity

I want to be able to to calculate the total quantity demanded by a particular customer. Current I query the DealDemandRequest table for all the records by a particular customer and then do a sum of the Quanity column.

However, we are expecting this table to be over 1 million record and it is reallly really slow right now.. Any better ways?

View 3 Replies

Forms Data Controls :: Calculate To Current Rowafter Update Quantity But Other Rows Don't Affect And Not Calculate

Jan 6, 2010

my code is calculate to current rowafter update quantity but other rows don't affect and not calculate i need to calculate all rows i think i need to use for loops but i dont know how to do it

[code]....

[Code]....

View 7 Replies

DataSource Controls :: Linq To Sql - Calculate Shopping Cart Total Amount

Jul 9, 2010

I am trying to calculate the total amount of shopping cart by multiplying the quantity with the product price and then sum up the sub results.I am doing this but it does not make the multiplication.

[Code]....

decimal? TotalAmount = (from shopCart in dc.KP_ShoppingCarts

View 1 Replies

DataSource Controls :: How To Calculate Current Financial Year Using Stored Procedure

Mar 6, 2010

I want to calculate the current financial year in my stored procedure and use it when generating a unique Id for the customer registring in my system.

View 2 Replies

DataSource Controls :: Calculate Average Duration To Cover A Route Trip?

Jan 10, 2010

I want to calculate average time to cover a duration of a route.

A route can have multiple trip between different time slots.

trip have TripStartTime and TripEndTime.

For more clear of the Qns for Qns please go to this URL and for table structure please go to this Url.

Trip Time = TripEndTime - TripStartTime from columnin the table.

I have to calculate Actual trips time for different time slots group by Fleet Id which is related to route no in another table..

View 2 Replies

Forms Data Controls :: GridView,calculate Value Based On Other Columns& Save To Datasource?

Nov 8, 2010

I had just started with Visual Studio 2008 + VB.net. I've now designed my tables, and basic gridview functions properly.Now I'm faced with the problem of having to calculate a value based on 2 - 3 columns/data in the gridview, display the result in an existing column in the same gridview, and saving the calculated value in the datasource.I had initially created the "Total" column as a textbox displaying a manually calculated amount that is saved in the datasource. Now, I want to change the field to auto-calculate based on 2 other columns.

View 4 Replies

DataSource Controls :: Select A Record From A Table And Insert Into B Table Using Linq?

Jun 29, 2010

how can i select a record from A table and insert into B table using linq?

View 2 Replies

DataSource Controls :: Way To Retrieve Data From A Table, Modify And Insert It Into Another Table

Jun 13, 2010

Basically i deal with two tables.i have a table T1 of the following format:id company_name i need to read this data and create a table T2 as followsi wrote the following code. it worked fine for retrieving data and modification but fails to insert the modified data into the 2nd table.the error is, it does not recognise the value for @token

ArrayList dynarr=new ArrayList(); // global variable
protected void Button2_Click(object sender, EventArgs e)
{
int row = 1; int i;
string strcmd = null;
string Connection = "Data Source=....";
SqlConnection conn = new SqlConnection(Connection);
string str = "select company_name from T1 where ID=@ID";
[code]...

View 2 Replies

DataSource Controls :: How To Insert StudentId From One Table Into Its Foreign Key In Another Table

Jun 9, 2010

I have two tables - Student and Advert.

I want to do the following;

1. Student is logged into their account (session is authenticated)

2. StudentID is primary key for that table, it is a foreign key for table Advert

3. When student is logged in, they create advert

What I want is their student Id to be input into the advert table when this new advert is created. How is this possible?

View 1 Replies

DataSource Controls :: How To Create The Pivot Table To Search The Table

Feb 26, 2010

I'm assuming I need to use a pivot table from what I've found so far. However, every one that I've seen has not had the date setup like I have.

I have a Gridview on my page which I need to be populated like so

Date NCMR

1/1/10-1/31/10 #

2/1/10-2/28/10 #

I want to do this for 10 months... bottom record being the current month (or last month). I would also like the Date to format to January 2010 I used the above date format because that is how it is in the table. Basically, I need to know how to create the pivot table to search the table for 1/*/10, 2/*/10, etc

View 3 Replies

DataSource Controls :: Update Another Table Automatically As Row Entered In First Table?

Mar 1, 2010

I'm sure this has been answered many times already, but I still can't seem to find exactly how to search for this issue, so apologies in advance.

Anyway, I have a VB script for entering a row of data into a table by a web user. When this row of data is entered, I wish to take some of the values from the columns of the "primary" table, and have that data automatically create a new row of data in a "secondary" table. I think I'm part of the way there, here is my script:

[code]...

"ProductsByMfr" is the "primary" table - the table that the user adds data into when the button click event is fired.

"DealerPricing" is a "secondary" table that I wish to have some of the data from the newly-entered row in ProductsByMfr copied into. Am I even close here?

View 8 Replies

DataSource Controls :: Update Table Based On Another Table?

Mar 1, 2010

I'm trying to update one my my tables from a field in another table.

I have Address fields on both tables and the old table has some addresses I need to copy over (I dont want to copy/paste or type them all in obviously). I basically need to:

[code]...

View 2 Replies

DataSource Controls :: How To Copy One Table To Another Table In Dataset Using C#

Jun 18, 2010

how to copy from one table to another table in dataset using c#

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved