473,387 Members | 3,750 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

I need help getting a weighted avg by site and date base on the gross and cost

Site Date Terminal Product Gross Cost
5360 1/1/2009 971 758 4500 1.1717
5360 1/2/2009 181 778 5999 1.166
5360 1/2/2009 971 758 3000 1.1717
5360 1/3/2009 971 758 6103 1.231
5360 1/4/2009 971 758 3003 1.231
5360 1/4/2009 971 758 4502 1.231
5360 1/6/2009 971 758 7499 1.2888
5360 1/7/2009 971 758 4202 1.2912
5360 1/7/2009 156 732 4499 1.16
5360 1/8/2009 971 758 3450 1.1759
5360 1/8/2009 156 732 4003 1.1785
5360 1/9/2009 971 758 4005 1.1903
5360 1/10/2009 971 758 8803 1.2182
5360 1/11/2009 971 758 6002 1.2182
5360 1/12/2009 971 758 6506 1.2182
5360 1/13/2009 971 758 6500 1.1993
5360 1/14/2009 971 758 3000 1.2997
5360 1/14/2009 971 758 8001 1.2997
5360 1/15/2009 971 758 7500 1.3066
5360 1/16/2009 971 758 2502 1.3057
5360 1/16/2009 971 758 7000 1.3057
Jan 21 '10 #1
1 1463
Stewart Ross
2,545 Expert Mod 2GB
Welcome to Bytes!

It helps us if you can frame your question in a way we can understand. I'm sorry to say you have not provided any context for your data, and the only question you pose is in the title of your post. We cannot answer you this way.

You need to be specific about what you require and what you have tried so far. It is impossible to guess at the 'weighted average' you mention, as you do not explain what it is the average of, nor what weighting factors are to be applied.

Help us to help you - ask us a question, don't just present us with some data and leave us to guess!

-Stewart
Jan 21 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: pmarisole | last post by:
I need help in calculating a score from a row of drop-down values. I need to use the onChange to tally the score as the user moves across 9 categories (with drop-down selection of 1-9 or N/A)...
3
by: Salad | last post by:
http://www.mathwords.com/w/weighted_average.htm At the above link gives an example of a weighted average. It uses the following example: Grades are often computed using a weighted average....
2
klarae99
by: klarae99 | last post by:
Hello, I am working in Access 2003 on an inventory database. Right now I am working on a report which will be used to fill in forms that our state requires periodically to collect taxes. Right...
1
by: =?ISO-8859-1?Q?Lasse_V=E5gs=E6ther_Karlsen?= | last post by:
I get the above error in some of the ASP.NET web applications on a server, and I need some help figuring out how to deal with it. This is a rather long post, and I hope I have enough details that...
5
by: jamesnkk | last post by:
I want to calculate the average price, I have a cost price table- tblcostPrice as below,Same part no can be purchase from different supplier at different cost. In my tblcostPrice I have 2...
10
by: Fred | last post by:
Hi guys, I was wondering how could i get a random number exemple between 1 and 100 but with n% of getting some value over a number x. Thanks a lot in advance. Fred
1
by: vikjohn | last post by:
I have a new perl script sent to me which is a revision of the one I am currently running. The permissions are the same on each, the paths are correct but I am getting the infamous : The specified...
1
by: qiubg | last post by:
There are many nodes in the map, each of which is connected to other nodes. One way traffic for all edges, for instance, from N1 to either N2 or N3, but from N2 or N3 can’t directly go back to N1....
2
by: aszush | last post by:
//Title: Programming Assignment 1 //Version: //Copyright: Copyright (c) 1999 //Author: Andrew //Company: //Description: Computes employee's weekly gross and net pay....
9
Catalyst159
by: Catalyst159 | last post by:
I have a form which is used to calculate residential Floor Area Ratio (FAR). The form is structured into seven parts as follows: Part A: Maximum FAR and Floor Area: Part B: Gross Floor Area of...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.