This forum has been archived. All content is frozen. Please use KDE Discuss instead.

[BUG] Strange format in numbers and trackers

Tags: None
(comma "," separated)
User avatar
JesusM
Registered Member
Posts
212
Karma
0
OS
Hello,

With the last compilation of Skrooge I've seen a change in few things (not everything is a bug, but there is at least one):

Image

  1. the way negative values are shown, and I know this is an usual way to present negative values in finance environment, but it is new for me in Skrooge (and I didn't find any way to configure it)
  2. a value for the tracker, in several ways:
    • the number is presented with a double pair of brackets, I don't know what they mean
    • why and what is this value? I assume it is the total aggregated for this tracker, but it has no meaning at all in this context as it is not even the total at the time of the transaction but the total at the day of the transaction, so different transactions for the same tracker on a same day will show always same total
    • Assuming the amount is the aggregated total, it is wrong, it is aggregating values but not taking into account different currencies used with that tracker (for the case in the screenshot I have used 4 different currencies :( ). It is aggregating "Amount entered_raw" when should use "Amount_raw" maybe?
    • Is there any way to remove it?
  3. while verifying where the wrong calculation came from I copied to the clipboard a bunch of transactions and pasted into a spreadsheet. It wasn't copied just the visible columns but all of them, so I realised that there are a lot of different but apparently duplicated columns, some stored as numbers, some as strings, some with the calculated balance ...
    • Amount, Amount_raw,Amount entered,Amount entered_raw
    • Expenditure,Expenditure_raw,Expenditure entered,Expenditure entered_raw
    • Income,Income_raw,Income entered, Income entered_raw
    • Balance, Balance_raw, Balance entered, Balance entered_raw
    • Tracker, Trackers
    For thousands of transactions isn't this a heavy overhead?
    Don't get me wrong, probably you need all these fields to track different values, but it looked weird to me.

By the way, I also realised my settings for Operations > Default values for special operations (Commission / Tax & Fake) was lost, rolling back to the default settings. Don't know if there is a change in the last commits forcing this.

For context, I am using a version signed as 2.23.0BETA, built today after cloning the git repository.

Thanks
//JM
User avatar
smankowski
Moderator
Posts
1047
Karma
7
OS
JesusM wrote:Hello,

With the last compilation of Skrooge I've seen a change in few things (not everything is a bug, but there is at least one):

Image

  1. the way negative values are shown, and I know this is an usual way to present negative values in finance environment, but it is new for me in Skrooge (and I didn't find any way to configure it)

Skrooge uses you system settings.
Launch systemsettings5 to change them.
JesusM wrote:
  • a value for the tracker, in several ways:
    • the number is presented with a double pair of brackets, I don't know what they mean
    • why and what is this value? I assume it is the total aggregated for this tracker, but it has no meaning at all in this context as it is not even the total at the time of the transaction but the total at the day of the transaction, so different transactions for the same tracker on a same day will show always same total

  • This is the sum of operations associated to this tracker.
    JesusM wrote:
  • Assuming the amount is the aggregated total, it is wrong, it is aggregating values but not taking into account different currencies used with that tracker (for the case in the screenshot I have used 4 different currencies :( ). It is aggregating "Amount entered_raw" when should use "Amount_raw" maybe?

  • Could you send me a sample file to reproduce this issue?
    JesusM wrote:
  • Is there any way to remove it?

  • If you want to remove the column, you can do it with the contextual menu on the header.
    JesusM wrote:
  • while verifying where the wrong calculation came from I copied to the clipboard a bunch of transactions and pasted into a spreadsheet. It wasn't copied just the visible columns but all of them, so I realised that there are a lot of different but apparently duplicated columns, some stored as numbers, some as strings, some with the calculated balance ...
    • Amount, Amount_raw,Amount entered,Amount entered_raw
    • Expenditure,Expenditure_raw,Expenditure entered,Expenditure entered_raw
    • Income,Income_raw,Income entered, Income entered_raw
    • Balance, Balance_raw, Balance entered, Balance entered_raw
    • Tracker, Trackers
    For thousands of transactions isn't this a heavy overhead?

  • Not a lot. And this is really interesting!
    JesusM wrote:Don't get me wrong, probably you need all these fields to track different values, but it looked weird to me.

    Internally, I don't need all these values.
    These values are created when you did the copy/paste.
    Formatted values are useful for reports.
    Raw values are useful for computation.
    The user can choose the values needed.
    JesusM wrote:By the way, I also realised my settings for Operations > Default values for special operations (Commission / Tax & Fake) was lost, rolling back to the default settings. Don't know if there is a change in the last commits forcing this.

    No change.
    JesusM wrote:For context, I am using a version signed as 2.23.0BETA, built today after cloning the git repository.

    Thanks
    //JM


    Skrooge, a personal finances manager powered by KDE
    Image - PayPal
    User avatar
    JesusM
    Registered Member
    Posts
    212
    Karma
    0
    OS
    smankowski wrote:Skrooge uses you system settings.
    Launch systemsettings5 to change them.


    Cannot find where it is configures like this, and other software is showing me negative values as usual.

    smankowski wrote:This is the sum of operations associated to this tracker.

    smankowski wrote:Could you send me a sample file to reproduce this issue?

    It is very strange. I anonymized the file to send it to you and suddenly the running balance is right :o
    When one anonymizes the file all trackers, accounts, payees, etc, are changed with generic names, but ... are the amounts also changed in any way? I was checking the transaction where I saw the problem and it was €74.99 in the original file but €74.00 in the anonymized one ... so not sure if that is the expected behaviour.

    In the original file the wrong running balance for that tracker is around €-102k when I see the transaction in the credit card account, but in the trackers page is €-24k (what is right)
    In the anonymized file, in the credit card page the runing balance for the tracker is around €-24k (what seems like right, but with some difference in the same way the transaction is rounded to the EUR), but in the tracker page the total balance is €-14k.
    This sounds crazy, but don't really know how to show you, I would need to send both original and anonymized files ???

    smankowski wrote:If you want to remove the column, you can do it with the contextual menu on the header.


    Yes, I saw I am using now "Trackers" (with the trailing S), but I never used that column before (I didn't know it existed even!) but "Tracker" without the S. I have no idea how it was changed! ???

    smankowski wrote:Not a lot. And this is really interesting!


    Why and what is interesting if I may ask?

    smankowski wrote:
    JesusM wrote:By the way, I also realised my settings for Operations > Default values for special operations (Commission / Tax & Fake) was lost, rolling back to the default settings. Don't know if there is a change in the last commits forcing this.

    No change.


    I am really confused. I remember I suggested you long time ago making these fields configurable, and I've been using with my own category/payee since you made it available. I cannot understand how suddenly it disappeared.

    Anyway, as usual, thanks for your work and answers.

    //JM


    Bookmarks



    Who is online

    Registered users: bartoloni, Bing [Bot], Google [Bot], Sogou [Bot], Yahoo [Bot]