  
| Author: | brickedboi  | | Posted: | May 13, 2024 02:28 | | Subject: | Re: Wanted List percent formula error | | Viewed: | 37 times | | Topic: | Suggestions | |
|
| In Suggestions, bajman writes:
| | The formula for the Wanted List Percentage does not properly calculate the percentage
of "HAVE" parts compared to the "TOTAL" Parts. Should the % shown be the amount
of "Have" pieces vs the total number of "Wanted" pieces, or is it intended to
provide some other detail? It's not showing the percent of LOTS completed,
and its not showing the percent of Parts with Have qty equaling the Want qty.
The formula seems to be working is a convoluted way, combining the percentage
for Want/Have and the percentage of Lots with any Have parts, and the total number
of lots.
Example #1 to illustrate the issue:
Wanted list with TWO lots.
Lot #1, Want 100, Have 10 (This is 10% of the want value)
Lot #2, Want 900, Have 0 (This is 0% of the want value)
The Percentage bar should show 1% (10 of 1,000), but the formula produces 5%.
Example #2 to illustrate the issue:
Lot #1, Want 100, Have 0 (This is 0% of the want value)
Lot #2, Want 900, Have 900 (This is 100% of the want value)
The percentage bar should show 90% (900 of 1,000), but the formula produces 50%.
Example #3 to illustrate the issue:
Lot #1, Want 100, Have 0 (This is 0% of the want value)
Lot #2, Want 450, Have 900 (This is 50% of the want value)
The percentage bar should show 45% (450 of 1,000), but the formula produces 25%.
In all examples, the percentage shown does not equate to anything tangible, real
or useful, and if very misleading
Unfortunately, this misinformation has led to many, many lost hours and much
frustration.
Please work to correct the formula, so that the percentage bar is a real, actual,
useful representation of the data.
If by some odd situation, the bar is performing as intended, please clarify its
intended function.
Thank you,
Brandon
|
Hi Brandon, have you been given an answer to your query or have any further info?
I was just thinking about this tonight as I have many partial sets and want to
know which to prioritize to complete but it's hard to tell what the completion
percentage bar indicates in wanted lists. Brickedboi.
|
|
Message is in Reply To:  Wanted List percent formula error - bajman (212)  | The formula for the Wanted List Percentage does not properly calculate the percentage of "HAVE" parts compared to the "TOTAL" Parts. Should the % shown be the amount of "Have" [...]
(40 months ago, Jan 31, 2021, to Suggestions) |
Message Has 1 Reply: Re: Wanted List percent formula error - yorbrick (1185) | [...] Bricklink averages things like this in strange ways. They do something similar for average sales prices too. They do a calculation per lot, then average that result over [...]
(10 days ago, May 13, 2024, to Suggestions) |
4 Messages in this Thread: Msg 1 - bajman (212) 40 months ago Jan 31, 2021 to Suggestions
 Msg 2 « - brickedboi (15) 10 days ago May 13, 2024 to Suggestions
  Msg 3 - yorbrick (1185) 10 days ago May 13, 2024 to Suggestions
Msg 4 - knxguy11340 (0) 9 days ago May 14, 2024 to Suggestions
Entire thread on one page
This message and all its replies on one page
|
|
Canada, Ontario
