|
hi Dear,
I have one item and its Avg Selling Price is 10 and Qty is 10 which makes its value to 10 * 10 =100
so now if i do some purchase and get one more item on the Price of 4 then it makes Qty 10+1 =11
and Avg Selling Price 100 + 4 =104
while if if divide 104 / 11 = 9.45 so its Avg Price becomes 9.45 and if i multiply
9.45 *11 =103.95
while my stock value is 104 means loss of 0.05
any Suggestion
Thanks in Adv
regards,
Mirza Rahman
|
|
|
|
|
softdev_sup wrote: any Suggestion
Yes, use a better calculator or rational numbers.
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
[My articles]
|
|
|
|
|
Dividing 104 by 11 is 9.4545454545454545....
Because you are truncating after two decimal places you lose numerical precision. If you do the calculation keeping everything explicitly in fraction notation, you will see it comes out to 104.
|
|
|
|
|
Thanks for replying but i have to store this value in database which is user defined and max up to 8 , any other solution
because when we round up to 8 same problem comes
|
|
|
|
|
I'd suggest storing the intermediate values and compute the value when you need it.
|
|
|
|
|
I suggest the same solution as Andrew.
|
|
|
|
|
Go with Andrew's suggestion. It is better to just do the calculations when you actually need to use them, rather than trying to store in the database and having the issue you are running into.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
I hope you don't mean you're storing these values as varchar/text/string etc.
|
|
|
|
|
When performing calculations on real numbers it's usually best to utilize the full precision of the machine or database environment, then do any rounding only at the final step. If that means you have to carry internal data to 6 decimals, so be it. It doesn't cost you anything in performance and will save a lot of grief when users start looking at your results.
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
|
|
|
|
|
Hi,
in order to preserve accuracy, you should keep track of the total amount
(104 in your example) and the total quantity (11). The Avg Selling Price
is of secondary importance. You should not perform a division (which
looses accuracy, especially if you apply rounding to the quotient) and
later try to undo it by multiplying again, just keep track of amount and count.
Amount has no precision problem, since it has a fixed resolution (e.g. 1 cent),
and count is an integer.
|
|
|
|
|
Excellent read[^]. It might solve a problem of mine if I can implement it a certain way.
|
|
|
|
|
I have a large number of articles. I have a large number of possible keywords. Each article has at least one keyword associated with it, but may have many keywords. There is a database containing a list of all articles and a boolean variable set to true for each keyword if that keyword applies.
A user has a list of all keywords and selects those which interest them.
I am trying to find a more elegant way to extract the list of relevant articles than a brute force SQL SELECT.
Any suggestions would be appreciated!
|
|
|
|
|
I guess you will not be able to escape from a select statement...maybe you could try to use a stored procedure for that, or try to optimize the select, but not without a select I think
Intelligence is almost useless for those who have nothing else!
Email: caiokf@gmail.com
|
|
|
|
|
I think your database design is not ideal.. You should have a table for all the articles and a table for all possible keywords. In a third table you save all keyword-article associations (using the primary key of the article and keyword).
|
|
|
|
|
There is ABC triangle randomly rotated on XY plane. A,B coords are known, ACB angle is 90'. AC length is known. How to find C coords????
chesnokov
|
|
|
|
|
Someone already showed you the way to go.
[^].
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
[My articles]
|
|
|
|
|
If the coordinates of A are (xa,ya) and the coordinates of B are (xb,yb) then the length AB is sqr((xa-xb)^2 + (ya-yb)^2)
The length CB is sqr(AB^2 - AC^2) (Length AC is known)
Thus (xc-xb)^2 + (yc-yb)^2 = CD^2
and (xc-xa)^2 + (yc-ya)^2 = AC^2
As xa, ya and xb,yb and AC are known just expand the two equations, subtract one from the other and the answer should drop out.
Haven't tried it, but the maths is OK!
|
|
|
|
|
but (xc-xb)^2 + (yc-yb)^2 = BC^2
It needs to solve 2nd order equations Ж8-О I hed the same before but if there is any easier method?
chesnokov
|
|
|
|
|
No, if you reeduce the equations you are left with a simple quadratic.
|
|
|
|
|
I think you need to provide more constraints as each side of the hypotenuse segment will result in 2 unique solutions.
A clue to get you going, the distance from the mid of the segment AB to C is equal to the half of |AB|
|
|
|
|
|
Hi arash. Your the expert in geometry, I've seen some of your projects.
There are no more constraints. That ones should be sufficient.
Would you help? to solve the problem?
Is it always half AB if ACB is 90'?
chesnokov
|
|
|
|
|
There are two ways of solving this problem, one is to do it algebraically by solving a set quartics based around the circumcircle, the other is simple geometric constructions.
I'll explain the 2nd one as its easier to understand and much easier to program a solution for.
1. Extend perpendiculars to the segment AB, 2 segments one each centered at A and B.
2. The end points for these 2 segments will be called A_0,A_1 and B_0,B_1
3. Extend diagonals from A_0 to B_1 and B_0 to A_1
4. The mid points between A and A_0 will be A_2, similar for the other side B_2
5. Extend diagonals from A_2 to B_0 and from B_2 to A_0
6. The intersection point between the segments A_2B_0 and A_0B_1 will be x_0, similar for the other two diagonals
7. Extend perpendiculars from x_0 and x_1 upon A_0B_0, the points of intersection will be p_0 and p_1
8. Extend segments from A to p_0 and B to p_1, called s_0 and s_1
9. The intersection point between s_0 and A_0B_1 will be C_0
10. The intersection point between s_1 and B_0A_1 will be C_1
11. Symmetric solution can be found by mirroring C_0 and C_1 about AB
A diagram of the solution can be found here:
http://www.partow.net/images/90degreetriangle.png[^]
Various routines in Wykobi can be used in conjunction with each other to solve this construction.
(perpendicular,mirror,project,closest_point_on_segment_from_point etc...)
have fun
|
|
|
|
|
That sounds like a whole bunch of work. A simpler solution is to find the mid-point of AB as D, and construct a circle of radius AD centered at D. Since it is given that angle ACB is 90 degrees, point C must also lie on this circle. Since it is given that the distance AC is known, construct a circle at A with a radius AC. Solve the two equations for the two circles for their intersection points. You are correct that there are two possible solutions, one solution on each side of AB.
Dave Augustine
|
|
|
|
|
Chesnokov Yuriy wrote: There is ABC triangle randomly rotated on XY plane. A,B coords are known, ACB angle is 90'. AC length is known. How to find C coords????
Start with simpler problem, A at origin, B at (0,c) (i.e. AB = c) and we know AC = b and BC = a. (In your problem you can easily find BC using pythagoras).
The two intersecting circles can be solved almost trivially giving the co-ords of C (choosing y>0 option) as
x = (b^2 + c^2 - a^2)/(2a) y = sqrt(b^2 - x^2)
now rotate co-ords until AB has correct slope (cos = (xb - xa)/c, sin = -(yb - ya)/c) and translate A into position.
So the general solution is:
xc = xa + (b * (xb-xa) - a*(yb-ya))*b/c^2
yc = ya + (b * (yb-ya) + a*(xb-xa))*b/c^2
Peter
"Until the invention of the computer, the machine gun was the device that enabled humans to make the most mistakes in the smallest amount of time."
|
|
|
|
|
I don't know why this thread has attracted the anonymous univoter. As far as I can see this is the simplest solution so far - can the univoter improve on it?
Peter
"Until the invention of the computer, the machine gun was the device that enabled humans to make the most mistakes in the smallest amount of time."
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
