https://bugs.kde.org/show_bug.cgi?id=380187
--- Comment #5 from Stephane MANKOWSKI <steph...@mankowski.fr> ---
With the current way of working:
-------|--------------------------|--------------------------
What | Day 1 | Day 2
-------|--------------------------|--------------------------
€ | 0.00 € [ 0 * 1.00 €] | 5.00 € [ 5 * 1.00 €]
Apple | 33.00 € [11 * 3.00 €] | -6.00 € [ -2 * 3.00 €]
Banana | 3.50 € [ 7 * 0.50 €] | 1.50 € [3 * 0.50 €]
-------|--------------------------|-------------------------
Total: | 36.50 € | 0.50 €
-------|--------------------------|-------------------------
Each operation amount is computed with the last value of its unit.
Reports are easily computed (and with good performances) just by adding
amounts.
With the current way of working in "cumulative mode":
-------|--------------------------|--------------------------
What | Day 1 | Day 2 (Cumulated)
-------|--------------------------|--------------------------
€ | 0.00 € | 5.00 € [ 5.00 € + 0.00 €]
Apple | 33.00 € | 27.00 € [ -6.00 € + 33.00 €]
Banana | 3.50 € | 2.00 € [ 1.50 € + 3.50 €]
-------|--------------------------|-------------------------
Total: | 36.50 € | 34.00 €
-------|--------------------------|-------------------------
The cumulative reports are just a sum of previous columns + the current
one. (easy and good performances)
With your proposal:
-------|--------------------------|--------------------------
What | Day 1 | Day 2
-------|--------------------------|--------------------------
€ | 0.00 € [ 0 * 1.00 €] | 5.00 € [ 5 * 1.00 €]
Apple | 27.50 € [11 * 2.50 €] | -6.00 € [ -2 * 3.00 €]
Banana | 35.00 € [ 7 * 5.00 €] | 1.50 € [3 * 0.50 €]
-------|--------------------------|-------------------------
Total: | 62.50 € | 0.50 €
-------|--------------------------|-------------------------
Each operation amount is computed with the value of its unit at the
date of the operation.
This way of computation is not good for performances because the value
of the unit won't be always the same.
With your proposal in "cumulative mode":
We can sum euro (as today)
-------|--------------------------|--------------------------
What | Day 1 | Day 2 (Cumulated)
-------|--------------------------|--------------------------
€ | 0.00 € | 5.00 € [ 5.00 € + 0.00 €]
Apple | 27.50 € | 21.50 € [ -6.00 € + 27.50 €]
Banana | 35.00 € | 36.50 € [ 1.50 € + 35.00 €]
-------|--------------------------|-------------------------
Total: | 62.50 € | 62.00 €
-------|--------------------------|-------------------------
The cumulative reports are just a sum of previous columns + the current
one. (easy and good performances)
But, I think that this is not you want.
We can sum quantities
-------|--------------------------|--------------------------
What | Day 1 | Day 2 (Cumulated)
-------|--------------------------|--------------------------
€ | 0.00 € | 5.00 € [ 5 * 1.00 €]
Apple | 27.50 € | 27.00 € [ (11-2) * 3.00 €]
Banana | 35.00 € | 5.00 € [ (7+3) * 0.50 €]
-------|--------------------------|-------------------------
Total: | 62.50 € | 37.00 €
-------|--------------------------|-------------------------
The computation of a cell is no more just a sum of €. This is a
sum(quantity) * unit amount at the date of the cell.
But if the column is a month, what is the date to take into account?
The date of the operation? The last day of the month? The first day of the
month?
I think, this should be the last day of the month. It means that the operation
doesn't have an amount but many amounts based on the report.
This could be confusing because the report sell with display an amount
and when the user will double click on the sell to see the corresponding
operation he will see an other amount !!!
Just to continue the discussion, you must know that some users have 2 accounts,
one in euro and an other one in dollars.
All reports/advice are computed based on the same value of the unit (the last
value).
If for example, this user spend 10 dollars in January and 10 dollars in
February, he doesn't have an alert.
Now, with your proposal, if the value of dollars change a lot, he will have an
alert saying he spent more (or less) than in the previous month.
So, I still have an important question:
-What is the amount of an operation?
-R1: As today, the quantity * last value of its unit
-R2: As in your proposal, the quantity * value of its unit at the date
of the operation
In this case:
Is it really what you want for report having periods of
time?
How can I compare values? (example: 10 dollars in
January ad 10 dollars in February)
-R3: An operation doesn't have an amount. The amount is computed
dynamically based on the report.
In this case, the impact on Skrooge could be huge !!!!
My proposal could be this one:
- The amount on an operation is still the quantity * last value of its
unit.
- No impact on advices
- No impact on reports
- No impact on balance
- No impact on monthly report
-In the unit page, you will be able to define if you want to see the
graph of:
- The history of the value of the selected unit (as today)
- The history of the amount owned of the selected unit (as
expected)
This solution has a limited impact and should answer to your request.
Thank you in advance for your answer and point of view.
--
You are receiving this mail because:
You are watching all bug changes.
